|
alastairwheatcroft -> Update Query... (5/2/2003 9:59:07)
|
Anyone....
This is the query line ...
fp_sQry= UPDATE Users SET x_firstname = ' ::x_firstname::' , x_lastname = ' ::x_lastname::' , UserName = ' ::UserName::' , x_email = ' ::x_email::' , Password = ' ::Password::' , x_company = ' ::x_company::' , x_address = ' ::x_address::' , x_city = ' ::x_city::' , x_state = ' ::x_state::' , x_zip = ' ::x_zip::' , x_country = ' ::x_country::' , x_phone = ' ::x_phone::' , x_fax = ' ::x_fax::' , x_website = ' ::x_website::' , PrefList = ' ::PrefList::' , Logo = ' ::Logo::' , Description = ' ::Description::' WHERE UserID= ' ::UserID::'
This is an update script to update a customised spooky login database, to allow customers to update their own details.
When the query is run, I get this message...
Technical Information (for support personnel)
Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/Smallholder/UpdateCompanyDetails.asp, line 14, column 16
fp_sQry= UPDATE Users SET x_firstname = ' ::x_firstname::' , x_lastname = ' ::x_lastname::' , UserName = ' ::UserName::' , x_email = ' ::x_email::' , Password = ' ::Password::' , AccountExpires = ' ::AccountExpires::' , x_company = ' ::x_company::' , x_address = ' ::x_address::' , x_city = ' ::x_city::' , x_state = ' ::x_state::' , x_zip = ' ::x_zip::' , x_country = ' ::x_country::' , x_phone = ' ::x_phone::' , x_fax = ' ::x_fax::' , x_website = ' ::x_website::' , PrefList = ' ::PrefList::' , Logo = ' ::Logo::' , Description = ' ::Description::' WHERE UserID= ' ::UserID::' ;
---------------^
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)
Page:
POST 234 bytes to /Smallholder/UpdateCompanyDetails.asp
POST Data:
UserID=139&x_firstname=Test&x_lastname=Test&UserName=Test&x_email=&Password=test&AccountExpires=&x_company=xx&x_address=&x_city=&x_state=&x_zip=&x_country=&x_phone=&x_fax=&x_website=&PrefList=&Logo=&D . . .
Any help greatly appreciated...[8|]
|
|
|
|
