Parse a mySQL query to type,table,fields and values

From: Gabriël vd Kruijk (gabriel[asdfasdf)
Date: 03/29/04 

Date: Mon, 29 Mar 2004 17:34:46 +0200

I've been searching for a while to discover a way to be able to check a
query.

I would like to be able to indentify the TYPE (insert,update,delete,select),
fields available in the query with the values going to be inserted in the
field...

I believe it's possible to create this, but maybe some has solved be problem
before, there's a function or code snippet...

Anyone any solutions?

(The reason for this is: I've got a class for mySQL connections. This class
contains a method "query", I would like that method to parse the query and
add the following fields: updatedby and updated (containing the ID of the
current user and the current date and time). So maybe I'm looking this from
the wrong site, but I've no clue how to solve this)

Thanks in advance,
Gabriël

Relevant Pages

  • Re: Parameter Query Form Problem
    ... This is what I used to make my query, its was a Microsoft support site. ... controls on the form so it can run the query. ... ContractStartDate ... Combo Box for searching Customer Name ...
    (microsoft.public.access.formscoding)
  • Re: Parameter Query Form Problem
    ... Dim stDocName As String ... This is what I used to make my query, its was a Microsoft support site. ... controls on the form so it can run the query. ... Combo Box for searching Customer Name ...
    (microsoft.public.access.formscoding)
  • Re: Help with Union & lookup
    ... I don't see where you are searching the surname field in the query you posted. ... BTW that "LIKE" expression I'm using works fine in another SQL query but with 3 sets of brackets. ...
    (microsoft.public.access.queries)
  • Pasting text into a combo-box for browsing
    ... I'm trying to improve the searching ... The query does this concatenation and is sorted ascending on ... I do all this with the mouse after Finding a record: I highlight ... functionality, I'd sure be open to that as well! ...
    (microsoft.public.access.forms)
  • Re: What would you do with 10 Man Years?
    ... >> searching. ... All more the surprise when I realized that your sample query is an old ... to build data structures characterizing the ... > index to create a second unindexed set, ...
    (comp.lang.lisp)