now one question, why revolution doesn't have something like php
mysql_real_escape() everyone here and his dog is implementing their own
escaping routines when it should be provided by the engine, specially since
mysql C library provides it, it is just a matter of wrapping around it.
On Mon,
Trevor Devore's sqlYoga has an escape function that will escape properly for
each type of database that Revolution can work with. Just one more reason to
check it out! http://www.bluemangolearning.com/revolution/
Bob
On May 24, 2010, at 8:57 AM, Andre Garzia wrote:
now one question, why
I agree that sqlYoga is marvelous, but we can't use it in the context of
revServer, thats why it woul pay well to have such function on the engine.
Andre
On Mon, May 24, 2010 at 2:19 PM, Bob Sneidar b...@twft.com wrote:
Trevor Devore's sqlYoga has an escape function that will escape properly
Hi Andre.
You mean using Revlets? I can see that being an issue. I thought the question
was general Revolution use. I access the On-Rev mySQL database with sqlYoga
fine, but you are probably thinking of a different application.
Bob
On May 24, 2010, at 10:24 AM, Andre Garzia wrote:
I
no, revLets can use sqlYoga, revServer can't... revServer right now is only
available on On-Rev.com it is a PHP like engine for Rev, and it needs some
improvements...
On Mon, May 24, 2010 at 2:30 PM, Bob Sneidar b...@twft.com wrote:
Hi Andre.
You mean using Revlets? I can see that being an
Hi
I am attempting to teach myself the rudiments of using mySQL databases
on on-rev. To this end I have created and populated a simple single
table database of six fields - a catalogue of DVD titles.
I am coming across problems when I attempt to search of my CERTIFICATE
field which is VARCHAR of
Hi Ian,
for varchar fields in a where clause:
put single quotes around the searchstring
e.g.: where certificate = '12a'
the like operator is only necessary if you want to use a pattern
e.g.: where name like '%Knight'
HTH
Wolfgang
Am 23.05.2010 15:12, schrieb Ian McKnight:
Hi
I am
Hi Wolgang
I just tried your suggestion and it works perfectly.
Thanks
Ian
On 23 May 2010 14:35, G. Wolfgang Gaich gwolfg...@gaich.de wrote:
Hi Ian,
for varchar fields in a where clause:
put single quotes around the searchstring
e.g.: where certificate = '12a'
the like operator is
Make sure you enclose values in real quotes. Mysql seems to handle
numerical values without quotes but when a value is text it will
interpret the text as a column name if it's not in quotes.
Bob Sneidar
IT Manager
Calvary Chapel CM
Sent from iPhone
On May 23, 2010, at 6:12, Ian McKnight
Thanks for the reminder Bob.
On 24 May 2010 03:37, Bob Sneidar b...@twft.com wrote:
Make sure you enclose values in real quotes. Mysql seems to handle numerical
values without quotes but when a value is text it will interpret the text as
a column name if it's not in quotes.
--
Regards
10 matches
Mail list logo