|
 |
asp_web_howto thread: Using Querystring to display database information
Message #1 by "Jonathan Marshall" <jdmarsh2g@h...> on Tue, 27 Nov 2001 18:58:19 +0000
|
|
<html><div style='background-color:'><DIV>ASP DATABASES<BR>1). If I set a cookie
into ones harddrive. That cookie being saved will be the user ID. <BR> How do I request a cookie
place it into a variable then use that variable value to build a SQL <BR> string. How do I get
this value and get it into the form or into the database from a cookie. </DIV>
<DIV>2). How do you use a querystring to get to a database record (ex. asp?PeopleID=21)
etc...<BR> The goal Im trying to reach is to have a the user search through records that they
want displayed<BR> through the search will display a <a href"" including the querystring
in the href that will direct<BR> the user to an update form for that record.</DIV>
<DIV>3). Can anyone direct me to some good javascript form validation scripts out there. </DIV></div><br
clear=all><hr>Get your FREE download of MSN Explorer at <a
href='http://go.msn.com/bql/hmtag_itl_EN.asp'>http://explorer.msn.com</a><br></html>
Message #2 by "Jason Salas" <jason@k...> on Wed, 28 Nov 2001 09:39:06 +1000
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0085_01C177F0.86158C20
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi Jonathan,
Based on everything you want to do, you might want to look into getting
a copy of Macromedia's "Dreamweaver Ultradev 4"...it'll do everything
you want to do and more.
http://www.macromedia.com/software/ultradev/
----- Original Message -----
From: Jonathan Marshall
To: ASP Web HowTo
Sent: Wednesday, November 28, 2001 4:58 AM
Subject: [asp_web_howto] Using Querystring to display database
information
ASP DATABASES
1). If I set a cookie into ones harddrive. That cookie being saved
will be the user ID.
How do I request a cookie place it into a variable then use that
variable value to build a SQL
string. How do I get this value and get it into the form or into
the database from a cookie.
2). How do you use a querystring to get to a database record (ex.
asp?PeopleID=3D21) etc...
The goal Im trying to reach is to have a the user search through
records that they want displayed
through the search will display a <a href"" including the
querystring in the href that will direct
the user to an update form for that record.
3). Can anyone direct me to some good javascript form validation
scripts out there.
-------------------------------------------------------------------------
-----
Get your FREE download of MSN Explorer at http://explorer.msn.com
$subst('Email.Unsub')
Read the future with ebooks at B&N
http://service.bfast.com/bfast/click?bfmid=3D2181&sourceid=3D38934667&cat
egoryid=3Drn_ebooks
Message #3 by "Daniel O'Dorisio" <daniel@o...> on Tue, 27 Nov 2001 19:21:53 -0500
|
|
ugghh.. no no no.. go learn ASP, ADO, SQL.. just get the beginning asp 3.0
from WROX, im not affiliated i just like thier stuff..
sure ultradev will work.. but in the long run you will kick your self.. many
times.
daniel
--
-----------------------------
Daniel O'Dorisio
daniel@o...
www.odorisio-networks.com
-----------------------------
"Jason Salas" <jason@k...> wrote in message news:123908@a..._web_howto...
Hi Jonathan,
Based on everything you want to do, you might want to look into getting a
copy of Macromedia's "Dreamweaver Ultradev 4"...it'll do everything you want
to do and more.
http://www.macromedia.com/software/ultradev/
----- Original Message -----
From: Jonathan Marshall
To: ASP Web HowTo
Sent: Wednesday, November 28, 2001 4:58 AM
Subject: [asp_web_howto] Using Querystring to display database information
ASP DATABASES
1). If I set a cookie into ones harddrive. That cookie being saved will be
the user ID.
How do I request a cookie place it into a variable then use that
variable value to build a SQL
string. How do I get this value and get it into the form or into the
database from a cookie.
2). How do you use a querystring to get to a database record (ex.
asp?PeopleID=21) etc...
The goal Im trying to reach is to have a the user search through records
that they want displayed
through the search will display a <a href"" including the querystring in
the href that will direct
the user to an update form for that record.
3). Can anyone direct me to some good javascript form validation scripts out
there.
Get your FREE download of MSN Explorer at http://explorer.msn.com
Read the future with ebooks at B&N
http://service.bfast.com/bfast/click?bfmid=2181&sourceid=38934667&categoryid
=rn_ebooks
Message #4 by "Ken Schaefer" <ken@a...> on Wed, 28 Nov 2001 13:11:43 +1100
|
|
...and it'd be a nightmare to debug. Have you ever seen the code that
UltraDev generates? <shudder>
My recommendation would be a good book:
Beginning ASP v3 by Wrox Press is a good start:
http://www.amazon.com/exec/obidos/ASIN/1861003382/
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Jason Salas" <jason@k...>
Subject: [asp_web_howto] Re: Using Querystring to display database
information
Hi Jonathan,
Based on everything you want to do, you might want to look into getting a
copy of Macromedia's "Dreamweaver Ultradev 4"...it'll do everything you want
to do and more.
http://www.macromedia.com/software/ultradev/
----- Original Message -----
From: Jonathan Marshall
To: ASP Web HowTo
Sent: Wednesday, November 28, 2001 4:58 AM
Subject: [asp_web_howto] Using Querystring to display database information
ASP DATABASES
1). If I set a cookie into ones harddrive. That cookie being saved will be
the user ID.
How do I request a cookie place it into a variable then use that
variable value to build a SQL
string. How do I get this value and get it into the form or into the
database from a cookie.
2). How do you use a querystring to get to a database record (ex.
asp?PeopleID=21) etc...
The goal Im trying to reach is to have a the user search through
records that they want displayed
through the search will display a <a href"" including the querystring
in the href that will direct
the user to an update form for that record.
3). Can anyone direct me to some good javascript form validation scripts
out there.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Message #5 by "Jason Salas" <jason@k...> on Wed, 28 Nov 2001 12:13:31 +1000
|
|
Hi guys,
I just recommended that b/c a lot of DB-driven functionality for the
non-programmer. I'm hardcore into code myself, but that's the route I
normally advise people go if they haven't got the time to learn complex DB
functions and SQL.
jas :)
----- Original Message -----
From: "Ken Schaefer" <ken@a...>
To: "ASP Web HowTo" <asp_web_howto@p...>
Sent: Wednesday, November 28, 2001 12:11 PM
Subject: [asp_web_howto] Re: Using Querystring to display database
information
> ...and it'd be a nightmare to debug. Have you ever seen the code that
> UltraDev generates? <shudder>
>
> My recommendation would be a good book:
> Beginning ASP v3 by Wrox Press is a good start:
> http://www.amazon.com/exec/obidos/ASIN/1861003382/
>
> Cheers
> Ken
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> From: "Jason Salas" <jason@k...>
> Subject: [asp_web_howto] Re: Using Querystring to display database
> information
>
>
> Hi Jonathan,
>
> Based on everything you want to do, you might want to look into getting a
> copy of Macromedia's "Dreamweaver Ultradev 4"...it'll do everything you
want
> to do and more.
>
> http://www.macromedia.com/software/ultradev/
>
> ----- Original Message -----
> From: Jonathan Marshall
> To: ASP Web HowTo
> Sent: Wednesday, November 28, 2001 4:58 AM
> Subject: [asp_web_howto] Using Querystring to display database
information
>
>
> ASP DATABASES
> 1). If I set a cookie into ones harddrive. That cookie being saved will
be
> the user ID.
> How do I request a cookie place it into a variable then use that
> variable value to build a SQL
> string. How do I get this value and get it into the form or into the
> database from a cookie.
> 2). How do you use a querystring to get to a database record (ex.
> asp?PeopleID=21) etc...
> The goal Im trying to reach is to have a the user search through
> records that they want displayed
> through the search will display a <a href"" including the
querystring
> in the href that will direct
> the user to an update form for that record.
> 3). Can anyone direct me to some good javascript form validation scripts
> out there.
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
>
$subst('Email.Unsub')
>
> Read the future with ebooks at B&N
>
http://service.bfast.com/bfast/click?bfmid=2181&sourceid=38934667&categoryid
=rn_ebooks
>
Message #6 by "Daniel O'Dorisio" <daniel@o...> on Tue, 27 Nov 2001 21:33:27 -0500
|
|
yeah.. that code is FFFAAARRRR from pretty.. you can allmost just forget
debugging it.. horrible context switching too..
anyway..
daniel
--
-----------------------------
Daniel O'Dorisio
daniel@o...
www.odorisio-networks.com
-----------------------------
"Ken Schaefer" <ken@a...> wrote in message
news:123938@a..._web_howto...
>
> ..and it'd be a nightmare to debug. Have you ever seen the code that
> UltraDev generates? <shudder>
>
> My recommendation would be a good book:
> Beginning ASP v3 by Wrox Press is a good start:
> http://www.amazon.com/exec/obidos/ASIN/1861003382/
>
> Cheers
> Ken
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> From: "Jason Salas" <jason@k...>
> Subject: [asp_web_howto] Re: Using Querystring to display database
> information
>
>
> Hi Jonathan,
>
> Based on everything you want to do, you might want to look into getting a
> copy of Macromedia's "Dreamweaver Ultradev 4"...it'll do everything you
want
> to do and more.
>
> http://www.macromedia.com/software/ultradev/
>
> ----- Original Message -----
> From: Jonathan Marshall
> To: ASP Web HowTo
> Sent: Wednesday, November 28, 2001 4:58 AM
> Subject: [asp_web_howto] Using Querystring to display database
information
>
>
> ASP DATABASES
> 1). If I set a cookie into ones harddrive. That cookie being saved will
be
> the user ID.
> How do I request a cookie place it into a variable then use that
> variable value to build a SQL
> string. How do I get this value and get it into the form or into the
> database from a cookie.
> 2). How do you use a querystring to get to a database record (ex.
> asp?PeopleID=21) etc...
> The goal Im trying to reach is to have a the user search through
> records that they want displayed
> through the search will display a <a href"" including the
querystring
> in the href that will direct
> the user to an update form for that record.
> 3). Can anyone direct me to some good javascript form validation scripts
> out there.
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
>
>
Message #7 by "Drew, Ron" <RDrew@B...> on Thu, 29 Nov 2001 15:54:03 -0500
|
|
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C17917.FA260950
Content-Type: text/plain
3 questions...umm...
question 1 ...I dont use alot of cookies because some people set their
browsers to not allow them
question 3 ...depends on what type of validation you want 2 good sites are
http://www.irt.org <http://www.irt.org> and
http://www.javascript.internet.com <http://www.javascript.internet.com>
question 2....build your select statement then response.write it for
verification after it looks good add the rest
' Response.Write mySQL
' Use the key for the table as the driver for the view
idfield="TableID"
' Where do you want to go next.....
scriptresponder="your2.asp"
set conntemp=server.createobject("adodb.connection")
conntemp.open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\InetPub\wwwroot\your.mdb;" & _
"User Id=admin;" & _
"Password=;"
set rstemp=conntemp.execute(mySQL)
howmanyfields=rstemp.fields.count -1
%>
<table align="center" border="1">
<tr>
<td valign="top"> </td>
<% 'Put Headings On The Table of Field Names
for i=0 to howmanyfields %>
<td align=center><b><%=rstemp(i).name %></b></td>
<% next %>
</tr>
<% ' Now lets grab all the records
do while not rstemp.eof %>
<tr><td valign="top">
<%my_link=scriptresponder & "?which=" & rstemp(idfield)%>
<a HREF="<%=my_link%>">View</a></td>
<% for i = 0 to howmanyfields%>
<td valign="top"><%=rstemp(i)%></td>
<% next %>
</tr>
<%
rstemp.movenext
loop
rstemp.close
set rstemp=nothing
conntemp.close
set conntemp=nothing
%>
</table>
-----Original Message-----
From: Jonathan Marshall [mailto:jdmarsh2g@h...]
Sent: Tuesday, November 27, 2001 1:58 PM
To: ASP Web HowTo
Subject: [asp_web_howto] Using Querystring to display database information
ASP DATABASES
1). If I set a cookie into ones harddrive. That cookie being saved will be
the user ID.
How do I request a cookie place it into a variable then use that
variable value to build a SQL
string. How do I get this value and get it into the form or into the
database from a cookie.
2). How do you use a querystring to get to a database record (ex.
asp?PeopleID=21) etc...
The goal Im trying to reach is to have a the user search through records
that they want displayed
through the search will display a <a href"" including the querystring in
the href that will direct
the user to an update form for that record.
3). Can anyone direct me to some good javascript form validation scripts out
there.
_____
Get your FREE download of MSN Explorer at http://explorer.msn.com
<http://go.msn.com/bql/hmtag_itl_EN.asp>
$subst('Email.Unsub')
Read the future with ebooks at B&N
http://service.bfast.com/bfast/click?bfmid=2181&sourceid=38934667&categoryid
=rn_ebooks
|
|
|
View Cart
