site assist & datassist tutorials
Hi
I am trying to build an online search facility for qualifications and training which will have a user admin area so that training providers can add their own items of training.
For practice I have followed the tutorial for siteassist using the administrator-all templatetemplate and then used data assist wizard to create pages using the blue_sky_music db.
The initial problem I encountered was in trying to open the created pages where I got the following error message in explorer when trying to open items_search.asp;
Error Type:
Active Server Pages, ASP 0141 (0x80004005)
The @ command can only be used once within the Active Server Page.
/trainingportal/Items_Search.asp, line 16
this was due to the following line of code
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
I noted that <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> had been added to the first line of code. if I remove the codepage 65001 line then I can view the search page in explorer....the same applied to other pages re codepage5001.
after removing as eplained above I could search for products and view results and details. However I experienced another issue when attempting to update or insert.
If I click the update button I get the following error;
Error Type:
ADODB.Command (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/trainingportal/Items_Update.asp, line 9
pointing to this line of code;
WADADynListItemCategory_cmd.ActiveConnection = MM_connBluesky_STRING
and when I click insert I get the following error after adding new product details and clicking insert;
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/trainingportal/Items_Insert.asp, line 38
which points to the following line of code on the items_insert.asp page;
MM_editCmd.Execute()
can you please point me in the right direction
Cheers
Robbie