--- K <[EMAIL PROTECTED]> wrote:
>
> I have a strange behavior I cannot explain. When I
> create a SQL statement like below.
>
>
> SELECT ca,cb,cc from :1 where fa=:2
>
> In this case :1 and :2 is sent to the database with
> single quotes ('') around it am I configuring
> something wrong? Is there a option to stop this?
>
> K
>
Hi Kevin,
You aren't doing anything wrong, and it shouldn't be
causing problems ; there is no option to stop it, but
you can always use the merge() function to build your
queries ; example :
--
put "Foo" into tTable
put 123456 into tRecID
put merge("SELECT ca,cb,cc FROM [[tTable]] WHERE
fa=[[tRecID]]") into tSQLQuery
--
Hope this helped,
Jan Schenkel.
=====
"As we grow older, we grow both wiser and more foolish at the same time." (La
Rochefoucauld)
__________________________________
Do you Yahoo!?
Yahoo! Domains � Claim yours for only $14.70/year
http://smallbusiness.promotions.yahoo.com/offer
_______________________________________________
use-revolution mailing list
[EMAIL PROTECTED]
http://lists.runrev.com/mailman/listinfo/use-revolution
