Hi Sergey,
When I use either post or get method I get a contract and information back
but not the one that I was looking for.

When I say it doesn't work I mean: When using the following sql statement
cmdTmp.CommandText = 'SELECT ResellerData.`Contract Number`, `Schedule Tracking`.`Customer
Name`, `Schedule Tracking`.DateReceived, `Schedule Tracking`.TimeReceived,
`Schedule Tracking`.Country, `Schedule Tracking`.`Currency` FROM ResellerData,
`Schedule Tracking` WHERE ResellerData.`Contract Number` = `Schedule Tracking`.`Contract
Number`';

It returns all relevant data but for a contract number I have not entered.

When I use sql statement:
//cmdTmp.CommandText = "SELECT ResellerData.`Contract Number`, `Schedule
Tracking`.`Customer Name`, `Schedule Tracking`.DateReceived, `Schedule Tracking`.TimeReceived,
`Schedule Tracking`.Country, `Schedule Tracking`.`Currency` FROM ResellerData,
`Schedule Tracking` WHERE ResellerData.`Contract Number`= '" & ContractID
& "'";

It returns nothing, not even an error message.

With this I am using the Post method in the first ASP form and I
declare ContractID as
var ContractID = Request.Form("ContractID")

Hope you have enough information. Thank you

Valerie.




"Sergey" <sctrl@hotmail.com.spam> wrote:
>First make sure that ContractID is filled in, do something like
>Response.Write ContractID : Response.End ' Will show ContractID contents

and
>stop processing
>
>If ContractID is empty then there's a problem with posting a form, maybe
>typo in input box ID or using GET instead of POST.
>If ContractID contains whatever you put in then the problem is with
>database/SQL statement.
>You said it doesn't work, what happens? Do you get an error? Empty
>recordset? ...
>
>--
>Sergey Kats
>http://codebump.net
>
>"valerie" <dolan_valerie@hotmail.com> wrote in message
>news:3ab23ba0@news.devx.com...
>>
>> "Kris Eiben" <eibenkthisisforspammers@yahoo.com> wrote:
>> >If the form method is post, then
>> >ContractID = request.form("ContractID")
>> >If the form method is get, then
>> >ContractID = request.querystring("ContractID")

>>
>> I have used
>> ContractID = request.form("ContractID")
>> But it does'nt work
>>
>>

>
>