text submit to sql with js

[mapnapkin]

I'm trying to use Jacob Gilley calendar script from

http://www.asp101.com/articles/jacob/calendar/default.asp

to send a the date output to a sql string in another asp page to show past logs from past days... into something like

rs.Open "Select FirstName, LastName, Company, Phone, Cell, For, Message, Urgent, Status from Contacts where Date='('$date')' ORDER BY Time DESC",conn

this is my first asp application so i don't really know where to go for help.
I would appreciate any direction or help.

Thank You

 

[vbkris]

do u wan this query to work? or do u want to know how it works?

rs.Open "Select FirstName, LastName, Company, Phone, Cell, For, Message, Urgent, Status from Contacts where Date='('$date')' ORDER BY Time DESC",conn

query to work:
set con=Server.CreateObject("ADODB.Connection&quot
set rs=Server.CreateObject("ADODB.Recordset&quot

con.open "ConnectionString" 'Building it is a totally different thing.

rs.Open "Select FirstName, LastName, Company, Phone, Cell, For, Message, Urgent, Status from Contacts where Date='('$date')' ORDER BY Time DESC",conn

 

[mapnapkin]

ya... I have that part, I was just showing where i needed the variable to go.. the problem is that the calendar script is hard to change (for me) to get it to post the date to the next page

 

[vbkris]

what variable do u mean?

 

[mapnapkin]

Maybe variable is the wrong word... what i need to do is get
#" & date & "#
from my calendar page into the postto page

into this(below)
rs.Open "Select * from Contacts where Date Like #" & date & "# ORDER BY Time DESC",conn

 

[vbkris]

date=request("FieldWhichHoldsDateValue&quot

if the calender is a popup then pass the variable as a query string.
date=request("QuerStringValue&quot

 

[mapnapkin]

ah... ok I'll give that try

thank you