|
 |
access_asp thread: javascript submit to sql
Message #1 by "dwayne morman" <souptooth@y...> on Sat, 22 Mar 2003 06:40:35
|
|
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
Message #2 by syed moiz <sa_moiz@y...> on Sat, 22 Mar 2003 03:11:22 -0800 (PST)
|
|
hi,
try to use this sql query for you example
rs.Open "Select FirstName, LastName, Company, Phone,
Cell, For, Message,
Urgent, Status from Contacts where Date Like
#" & date & "#
ORDER BY Time DESC",conn
try this and mail me back if you encounter any errors
with error description and code.
Enjoy Programming
Syed...
--- dwayne morman <souptooth@y...> wrote:
> 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
__________________________________________________
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
Message #3 by dwayne morman <souptooth@y...> on Sun, 23 Mar 2003 04:00:56 -0800 (PST)
|
|
cool, I didn't know that but... my biggest problem is getting the date output to the new page from this calendar script from
http://www.asp101.com/articles/jacob/calendar/default.asp
I think i may have to start looking for other options which sucks cause i've put a lot of work into this thing
thankyou for you help
syed moiz <sa_moiz@y...> wrote:hi,
try to use this sql query for you example
rs.Open "Select FirstName, LastName, Company, Phone,
Cell, For, Message,
Urgent, Status from Contacts where Date Like
#" & date & "#
ORDER BY Time DESC",conn
try this and mail me back if you encounter any errors
with error description and code.
Enjoy Programming
Syed...
--- dwayne morman wrote:
> 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
__________________________________________________
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
---------------------------------
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
|
|
|
View Cart
