|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| ||||||||||||||||||||||||||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
March 27th, 2000, 07:07 AM
|
|||
|
|||
|
Variables in SQL string
<i><b>Originally posted by : Paul (pwil22@hotmail.com)</b></i><br />How do you use variables in an SQL string?<br /><br />The ID I have is stored in a variable called "thisdelegateid".<br /><br />How do I use this as a value in an SQL string to populate a table?<br /><br />i.e.<br /><br />SQL2 = "INSERT into Registration ([Conference Code], [Delegate ID]" &_ <br />"[Internet Reg], [Paying Organisation ID], MeetingFeesCode, " & _<br />"[Name Required]) VALUES ('ITMA 13th Annual Meeting', " &_<br />??????????, True, '" & _<br />Request.Form("txtPaying") & "','" & _<br />Request.Form("cboFees") & "','" & _<br />Request.Form("txtName") & "')" <br /><br />the variable "thisdelegateid" is a number.<br /><br />Any help any one could give me would be greatly appreciated <br /><br />Thanks<br /><br />Paul<br />
|
|
#2
March 27th, 2000, 08:55 AM
|
|||
|
|||
|
<i><b>Originally posted by : steve</b></i><br />strSampleValue = request("afieldfromform")<br />strsql3 = ""<br />strSQL3 = "INSERT INTO tblName(tblName.Value1, tblName.Value2) "<br />strSQL3 = strSQL3 & " SELECT "<br />strSQL3 = strSQL3 & "'" & strSampleValue & "' as text1, " <br />strSQL3 = strSQL3 & " request.form("somefieldwithnumbers") & " as text2 "<br /><br />here is some sample code using variables.<br /><br /><br />------------<br />Paul at 3/27/2000 5:07:28 AM<br /><br />How do you use variables in an SQL string?<br /><br />The ID I have is stored in a variable called "thisdelegateid".<br /><br />How do I use this as a value in an SQL string to populate a table?<br /><br />i.e.<br /><br />SQL2 = "INSERT into Registration ([Conference Code], [Delegate ID]" &_ <br />"[Internet Reg], [Paying Organisation ID], MeetingFeesCode, " & _<br />"[Name Required]) VALUES ('ITMA 13th Annual Meeting', " &_<br />??????????, True, '" & _<br />Request.Form("txtPaying") & "','" & _<br />Request.Form("cboFees") & "','" & _<br />Request.Form("txtName") & "')" <br /><br />the variable "thisdelegateid" is a number.<br /><br />Any help any one could give me would be greatly appreciated <br /><br />Thanks<br /><br />Paul<br />
|
|
| Viewing: ASP Free Forums > Programming > ASP Development > Variables in SQL string |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
