Eli:

Two suggestions:

1. Response.Write the contents of the variable with your SQL string to see
if it's being passed as you expect;

2. Post your code.

hth
ms
________________________________________________________

----- Original Message -----
From: "Eli Aroshas" <aganim@n...>
To: "Interdev_Programming" <interdev_programming@p...>
Sent: Sunday, October 14, 2001 11:42 AM
Subject: [interdev_programming] Inserting values inside SQL query


> Hi,
>
> I am using InterDev to write a database application, I want to insert a
> WHERE condition inside one of my SQL Recordsets, so the recordeset result
> would depend on one of the Textbox value.
>
> I was not able to do that. I got Errors on my SQL syntax. I tried
> WHERE work_num='Textbox1.value'
> and alike and no success.
>
> Thank You
>
> Eli Aroshas
>
> Email :aganim@n...
>
> Email :aganim@n...
>
>
>