Thanks Trevor, I found it by experimenting and from what others had
said. I then looked at your library stack and say the (very nicely
formatted and well written code). I forgot I could use your library
as an abstraction layer.
All the Best
Dave
On 1 Nov 2007, at 14:07, Trevor DeVore wr
Dave,
Variable substitution doesn't escape characters for in version of Rev
prior to 2.9. Just run all values you want to insert into the
database through a function such as the following. Note that the
PostGreSQL switch statement is based on what I read in the docs. I
haven't used PostGr
David Burgun wrote:
Hi,
I believe that even with variable substitution, you have to put '
around any non-numeric parameter.
Do you mean the data in the array? The reason I moved from just
sending the data in the SQL Statement directly was to get around the
problem that there may be quotes i
Hi,
I believe that even with variable substitution, you have to put '
around any non-numeric parameter.
Do you mean the data in the array? The reason I moved from just
sending the data in the SQL Statement directly was to get around the
problem that there may be quotes in the data to be i
I believe that even with variable substitution, you have to put ' around
any non-numeric parameter. Your SQL statement doesn't have that. The
13T01 is the time. It appears that the expression for the date is
getting evaluated as a math function.
I think your template SQL statement should be
Hi,
After finding out that the data I was sending with revExecuteSQL
needed to be escaped if it contains double-quotes or colon etc. I
decided it would be better to put the data into an array and use the
parameter substitution feature. When I run it now, I get the
following error: unreco