One other thing: the query is invalid
SELECT id,name FROM from test
should be
SELECT id,name FROM test
Thank you,
Ryan Sexton
On Nov 27, 2005, at 7:33 AM, Derek Stottlemyer wrote:
Hello istvan,
You can't have commas in zinc parameters, so you have to escape them
like so:
var query:String = "SELECT id,name FROM from test"
query=query.split(",").join("@c@") //"@c@" is a comma to zinc
mdm.selectfromdb (query);
You should check the MDM forum, they are very helpful and questions are
usually answered promptly.
http://www.mdmforum.com/
HTH,
Derek
-----Original message-----
From: kosztik istvan [EMAIL PROTECTED]
Date: Sun, 27 Nov 2005 05:11:29 -0500
To: "'Flashcoders mailing list'" flashcoders@chattyfig.figleaf.com
Subject: [Flashcoders] mdm zinc database question
hi all!
I got error when i try to send a select to my MS access database from
zinc. The error come whem in the SELECT i give more column name. The
same select with one column name is work perfectly. Of course these
colums are exists in my database.
example
there are an MS access database with test table.
test table hold 2 column: id, name
this select pop up an error
mdm.selectfromdb ("SELECT id,name FROM from test");
but this selects is work
mdm.selectfromdb ("SELECT id FROM from test");
or
mdm.selectfromdb ("SELECT name FROM from test");
do you know what is the problem?
cheers,
istvan
_______________________________________________
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders
_______________________________________________
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders
_______________________________________________
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders
