SQL statement conversion.

Results 1 to 2 of 2

Thread: SQL statement conversion.

  1. #1
    Join Date
    Dec 1969

    Default SQL statement conversion.

    How would i convert this to go with asp...<BR>SQL = "select t.firstname, t.lastname, h.referenceno, a.valuedesc site, a1.valuename department,<BR>a2.valuename priority, h.callerphone phone <BR>from helpdeskcalls h, tech t, appvalue a, appvalue a1, appvalue a2 <BR>where <BR>t.firstname = firstname <BR>AND h.callcloseddate IS NULL<BR>AND a.valuetype = &#039;HO&#039;<BR>AND a1.valuetype = &#039;DE&#039;<BR>AND a2.valuetype = &#039;PR&#039;<BR>AND h.techid = t.techid<BR>AND h.siteid = a.valueid<BR>AND h.deptid = a1.valueid<BR>AND h.priority = a2.valueid<BR><BR>i know that you connect other lines with &_ but when i do it, it doesn&#039;t seem to compile.

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL statement conversion.

    I persoannly would not bother writing it out on several lines, but if you really, really want to:<BR><BR>SQL = "Select blah blah"<BR>SQL = SQL & "&#060;space&#062;More SQL blah blah.."<BR><BR><BR><BR><BR> <BR>

Posting Permissions

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