query string mystery

artificiality

Registered User.
Local time
Today, 11:12
Joined
Jan 30, 2007
Messages
20
sqlSt = ""
sqlSt = sqlSt & "INSERT INTO RawData(RunID,fullName,name,category,type,subType,numberOfLines,virtual,date,namespace)"
sqlSt = sqlSt & " SELECT " & RunID & " ,fullName,name,category,type,subType,numberOfLines,virtual," & "#" & d & "#" & ",namespace FROM RawData "
sqlSt = sqlSt & " WHERE namespace = " & "'" & namespace & "'" & " AND RunID = " & id

id = 256

Why do I get on debug for sqlSt :

"INSERT INTO RawData(RunID,fullName,name,category,type,subType,numberOfLines,virtual,date,namespace) SELECT 257 ,fullName,name,category,type,subType,numberOfLines,virtual,#1/3/2007#,namespace FROM RawData WHERE namespace = 'customer.demo' AND RunID " Where is the id value ?
 
A,

Your string was truncated at 250-characters. Don't know why ... need more info ...

Wayne
 

Users who are viewing this thread

Back
Top Bottom