Zugg Software :: View topic

Newbie Joined: 13 Mar 2004 Posts: 3 Location: USA

I want to be able to use variables that expand inside ADO SQL statements...heres what I currently have.

quote:

#CALL @con.Execute( "INSERT INTO ftalk (name,comment) VALUES ('@friendname','@comment')")

Why do the variables not expand? What can I do to make them expand?

N

Newbie Joined: 17 Mar 2003 Posts: 5 Location: Canada

reply I don't know if this applies to your problem but variables can be expanded when surrounded <@variable> like that.

again I don't know if that will work in your situation but you can try.

Newbie Joined: 13 Mar 2004 Posts: 3 Location: USA

Yeah I thought that might work too, but it didn't.

:(

N

Posted: Sun Mar 14, 2004 12:12 am

Have you tried using the %expand(@friendname) method?

That may solve your problem.

SubAdmin Joined: 18 Nov 2001 Posts: 5182

Currently your SQL statement is contained in a set of quotes. This causes the parser to treat it literally.
#CALL @con.Execute( "INSERT INTO ftalk (name,comment) VALUES ('@friendname','@comment')")
Instead you should use the %concat function.
#CALL @con.Execute(%concat("INSERT INTO ftalk (name,comment) VALUES ('",@friendname,"','",@comment,"')"))

Newbie Joined: 13 Mar 2004 Posts: 3 Location: USA

okay I've determined that the real problem is variable expansion inside of quotes.

The only solution that I can think of, is %concat but %concat _requires_ quotes and you need some sort of escape character to insert a quote into a concat and I don't know it! very frustrating.

GURU Joined: 10 Oct 2000 Posts: 4379 Location: USA

No need for an escape character, the %char function will return the character of whatever ASCII code you supply:
#SH %concat("This is some text with a ", %char(34), " in it.")