Re: no parameterized query but query actually passed

From: "Marc Rohloff" <marcrohloff_ng@xxxxxxxxxxx>
Date: 31 Aug 2005 06:02:08 -0700

> $query = "SELECT * FROM Customer WHERE CustNo = :Number";
> ParamByName('Number').AsInteger := 4;
>
> I would like to see the SQL statement actually being passed, so with
> the parameters replaced by the actual values

The SQL is never sent with the actual values replaced. Usually
something like the following is sent to the server:
> "SELECT * FROM Customer WHERE CustNo = ?"
Then the parameters are sent seperately. If the SQL is prepared and
then executed several times the SQL will only be sent the first time
while the parameters are sent each time it is executed.

--
Marc

.

References:
- no parameterized query but query actually passed
  - From: Boefje

Prev by Date: no parameterized query but query actually passed
Previous by thread: no parameterized query but query actually passed
Index(es):
- Date
- Thread

Relevant Pages

Re: SQL string problem
... clean up your parameters before sending them to SQL. ... > You must "escape" any single quotes when sending SQL statements ... > Just pass your SQL statement through this function when opening your ... >> Here is the full SQL statement that is assigned to the strSQL ...
(microsoft.public.excel.programming)
Re: SQL Statement or Cursor
... > Your post seems to ask whether you're better off using a cursor or a sql ... > you can achieve this in a SQL Statement, but I'll offer a caution to you ... SQL Server's tsql doesn't have a rownum ... >> Initial Result Set but lacking Incrementing number. ...
(microsoft.public.sqlserver.programming)
Re: Populating a list -- table structure?
... this clears up a lot of issues and jargon with SQL. ... I think I'll have to try to get a query that will take the BKitIDs and the KitIDs and bring that information together. ... Queries (just shows the QBE grid for convenience -- ... and It really helps to use Aliases for tablenames as it makes the SQL statement shorter. ...
(microsoft.public.access.forms)
Re: Emailing a Report
... CTRL-G to Goto the debuG window -- look at the SQL statement ... The Sub LoopAgmtsSendEmail is highlighted by the Debugger. ...
(microsoft.public.access.modulesdaovba)
Re: SQL string problem
... You must "escape" any single quotes when sending SQL statements directly to ... Just pass your SQL statement through this function when opening your ... > Here is the full SQL statement that is assigned to the strSQL ...
(microsoft.public.excel.programming)