what is wrong in this sql syntex

Results 1 to 3 of 3

Thread: what is wrong in this sql syntex

  1. #1
    dip Guest

    Default what is wrong in this sql syntex

    textsql = "Insert into hr_rep_assignment " _<BR> & "(division_id,location_id,user_id)" _<BR> & " values (&#039" & div & "&#039,&#039" _<BR> & loc & "&#039,&#039" & struname & "&#039)" <BR><BR>this is my query but i am geting error ( Insert into hr_rep_assignment (division_id,location_id,user_id) values (&#039J, &#039,&#039F, &#039,&#039d&#039) )<BR>this is the output i am getting when i am doing reponse.write and gives me constrain error <BR>Please tell why i am getting extra space and extra commas

  2. #2
    Jairo Guest

    Default RE: what is wrong in this sql syntex

    Dip,<BR>Try writing out each of the values by itself and see what it&#039s actually storing.<BR>i.e. Response.Write div<BR>Response.Write loc<BR>Response.Write struname<BR><BR>HTH,<BR>Jairo<BR>http://www.citywebarchitects.com

  3. #3
    Sathiya Guest

    Default RE: what is wrong in this sql syntex

    Try Reponse.write div and Response.write struname, so that we can know correct value is assigned to this variable or not.<BR><BR>Sathiya

Posting Permissions

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