August 19th, 2004, 08:00 AM
|
|
Registered User
|
|
Join Date: May 2004
Location: Gold Coast Australia
Posts: 13
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Too few Parameters in my sql string
Sample 1 works ok where the 4 is, but I need to put the unbound text field Me.[Surname] in place of the 4 as in sample 2
Sample 1
Dim strsql As String
strsql = "INSERT INTO person (firstname,surname, house) VALUES ("
strsql = strsql & rs.Fields(0) + 1 & ", " & 4 & ", " & GetHouse() & ")"
db.Execute (strsql)
Sample 2 does not work, im not sure of the parameters that I may need to put around the unbound text field Me.[surname].value
sample 2
Dim strsql As String
strsql = "INSERT INTO person (firstname,surname, house) VALUES ("
strsql = strsql & rs.Fields(0) + 1 & ", " & Me.[Surname].Value & ", " & GetHouse() & ")"
db.Execute (strsql)
help would be appreciated
Phil
|
ASP Free Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
