little escape every now and then?
Thank you Dan!
Dan Nelson wrote:
In the last episode (May 04), Steve Pugh said:
Hello all, once again! Can anyone tell me why the following takes
place? In my VB app I am adding records to the table "Jobs" with
this code (trimmed way down - my act
was "ascii code equivalent (chr(39)" (I
tried single *and* double quotes). Sorry about that.
Steve Pugh wrote:
Hi Daniel,
I tried that to no avail (I had actually had the code set initially to
use single quotes thusly:
sqlstr = "INSERT INTO Jobs VALUES("' & _
Err...what I meant to say here was "ascii code equivalent (chr(39)" (I
tried single *and* double quotes). Sorry about that.
Steve Pugh wrote:
Hi Daniel,
I tried that to no avail (I had actually had the code set initially to
use single quotes thusly:
sqlstr = "INSERT I
Hi Daniel,
I tried that to no avail (I had actually had the code set initially to
use single quotes thusly:
sqlstr = "INSERT INTO Jobs VALUES("' & _
txtSceneFile & "')"
but it generated the same erroneous string. Using the ascii-code
equivalent (Chr(34) does the same.
It's just so
Every time I think I've got it, I am reminded thatI don't got it.
Hello all, once again! Can anyone tell me why the following takes
place? In my VB app I am adding records to the table "Jobs" with this
code (trimmed way down - my actual INSERT statement populates about 20
fields):
sqlstr
Hey gang, many thanks to all for pointing me in the right direction for
my previous "multiple selects" question. I moved to 4.1.1 and
implemented Udikarni's use of multiple sum()s instead of multiple
selects() and that stuff is all groovy now!
Of course, I'm beating my head on *another* wall n
Aha, that would explain it! I guess my next question would have to
be...is the the appropriate list to inquire as to the stability of the
current Alpha builds? My app is pretty timid in its use of SQL, mostly
SELECTS and a smattering of UPDATES and INSERTS on single tables. But
on the other
Hello, all!
I am porting my Visual Basic app over from MSDE to MySQL, and things so
far are going quite well. I've found most of the "gotcha" differences
in how I need to structure my queries, but I am having trouble with one
in particular.
In my original code, I could use one query to get a
