errors on adding to database

Results 1 to 2 of 2

Thread: errors on adding to database

  1. #1
    Join Date
    Dec 1969

    Default errors on adding to database

    im trying to add to a database but i keep on getting the following errors-please help if you can:<BR>Microsoft VBScript compilation error &#039;800a03f3&#039; <BR><BR>Expected &#039;=&#039; <BR><BR>/alisond/hot or not/myinfo.asp, line 21 <BR><BR>set "select username, firstname, surname, email, country, age, sex, sexual_orientation, hobbies_interests, No_votes, average_votes from Live where username = &#039;" & request.form("frmusername"), conn1<BR>------------^<BR><BR>cheers

  2. #2
    Join Date
    Dec 1969

    Default RE: errors on adding to database

    So many errors in there, it&#039;s unreal.<BR><BR>Why on earth did you consider this advanced?<BR><BR>For starters, that&#039;s doing a select, not an insert.<BR><BR>For second, you&#039;ve not enclosed the value of Request.Form("frmusername") properly in your query.<BR><BR>Third (and the main problem you&#039;re getting at the moment), the basic syntax for that line is completely wrong. Why are you using SET?<BR><BR>Craig.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts