realbasic-nug
[Top] [All Lists]

Re: Execute MySql query from file or from a edit field

To: REALbasic NUG <realbasic-nug at lists dot realsoftware dot com>
Subject: Re: Execute MySql query from file or from a edit field
From: David Glass <dglass at graymattercomputing dot com>
Date: Thu, 30 Jun 2005 14:50:30 -0700
Delivered-to: realbasic-nug at lists dot realsoftware dot com
References: <BAY102-F28C3B70E85C85BF641FFED7E30 at phx dot gbl>
Unless there is a typo in your SQL, this most assuredly won't work as your quotes don't match up.

However, given this SQL as an example, I wonder if your problem isn't a matter of escaping any quotes (single or double) in the edit field?

On Jun 30, 2005, at 13:03, the wiper wrote:


db.sqlexecute (" insert into test (test_1,test2) values ("a","b) // THIS WORK, via phpMyAdmin i see these values


--
David Glass - Gray Matter Computing
graymattercomputing.com - corepos.com
559-303-4915

Apple Certified Help Desk Specialist

_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>

<Prev in Thread] Current Thread [Next in Thread>