|
 |
access_asp thread: Regarding storing URL's in access2000
Message #1 by "manju_jacob" <manju_jacob@m...> on Thu, 24 Jan 2002 10:11:29 +0530
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0055_01C1A4BF.7DCCD810
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
charset="iso-8859-1"
I have a global.asa file in which connection to the ms access 2000db is
set
In access table I've a field which stores url of the files i have to
call in an asp page.
These url i'm storing as hyperlink..
Query is: Is it fine to store url's as hyperlinks? or should the
datatype be something else?
<% sql_findstud=3D"select * from stud"
Set RS_findstud=3DApplication("Conn").Execute(sql_findstud)
%>
The below syntax displays the fields cversion and ctitle in the HTML
page but curl is only not displayed...
<%=3DRS_findstud.Fields("cversion")%>
<%=3DRS_findstud.Fields("ctitle")%>
<a
href=3D<%=3DRS_findstud.Fields("curl")%>><%=3DRS_findstud.Fields("curl")%
></a>
Could Someone Help ME With this problem...
Regards,
Manju
------=_NextPart_000_0055_01C1A4BF.7DCCD810
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html;
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4807.2300" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>I have a global.asa file in which
connection to the
ms access 2000db is set</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>In access table I've
a field which
stores url of the files i have to call in an asp page.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>These url i'm storing as
hyperlink..</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><U>Query is:</U> Is it fine
to store
url's as hyperlinks? or should the datatype be something else?
</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2><% sql_findstud=3D"select * from
stud"</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Set
RS_findstud=3DApplication("Conn").Execute(sql_findstud)<BR>%></FONT></
DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>The below syntax displays the fields
cversion and
ctitle in the HTML page but curl is only not displayed...</FONT></DIV>
<DIV><FONT face=3DArial
size=3D2><%=3DRS_findstud.Fields("cversion")%></FONT></DIV>
<DIV><FONT face=3DArial
size=3D2><%=3DRS_findstud.Fields("ctitle")%></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><a
href=3D<%=3DRS_findstud.Fields("curl")%>><%=3DRS_findstud.Fie
lds("curl")%></a></FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Could Someone Help ME With this
problem...</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Regards,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Manju</FONT></DIV></BODY></HTML>
------=_NextPart_000_0055_01C1A4BF.7DCCD810--
Message #2 by "Mark Brogan" <stmusicdude@j...> on Thu, 24 Jan 2002 12:40:26 -0000
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0001_01C1A4D4.4CB50BC0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
Following on from that can you make the links stored appear as links
when called from the database?
Mark
-----Original Message-----
From: manju_jacob [mailto:manju_jacob@m...]
Sent: 24 January 2002 04:41
To: Access ASP
Subject: [access_asp] Regarding storing URL's in access2000
I have a global.asa file in which connection to the ms access 2000db is
set
In access table I've a field which stores url of the files i have to
call in an asp page.
These url i'm storing as hyperlink..
Query is: Is it fine to store url's as hyperlinks? or should the
datatype be something else?
<% sql_findstud="select * from stud"
Set RS_findstud=Application("Conn").Execute(sql_findstud)
%>
The below syntax displays the fields cversion and ctitle in the HTML
page but curl is only not displayed...
<%=RS_findstud.Fields("cversion")%>
<%=RS_findstud.Fields("ctitle")%>
<a
href=<%=RS_findstud.Fields("curl")%>><%=RS_findstud.Fields("curl")%></a>
Could Someone Help ME With this problem...
Regards,
Manju
$subst('Email.Unsub').
Message #3 by "Mark Brogan" <stmusicdude@j...> on Thu, 24 Jan 2002 12:42:44 -0000
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0008_01C1A4D4.9EE515C0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
Please ignore this request I have worked it out.
Thank anyway
-----Original Message-----
From: Mark Brogan [mailto:stmusicdude@j...]
Sent: 24 January 2002 12:40
To: Access ASP
Subject: [access_asp] RE: Regarding storing URL's in access2000
Following on from that can you make the links stored appear as links
when called from the database?
Mark
-----Original Message-----
From: manju_jacob [mailto:manju_jacob@m...]
Sent: 24 January 2002 04:41
To: Access ASP
Subject: [access_asp] Regarding storing URL's in access2000
I have a global.asa file in which connection to the ms access 2000db is
set
In access table I've a field which stores url of the files i have to
call in an asp page.
These url i'm storing as hyperlink..
Query is: Is it fine to store url's as hyperlinks? or should the
datatype be something else?
<% sql_findstud="select * from stud"
Set RS_findstud=Application("Conn").Execute(sql_findstud)
%>
The below syntax displays the fields cversion and ctitle in the HTML
page but curl is only not displayed...
<%=RS_findstud.Fields("cversion")%>
<%=RS_findstud.Fields("ctitle")%>
<a
href=<%=RS_findstud.Fields("curl")%>><%=RS_findstud.Fields("curl")%></a>
Could Someone Help ME With this problem...
Regards,
Manju
$subst('Email.Unsub').
$subst('Email.Unsub').
Message #4 by "manju_jacob" <manju_jacob@m...> on Thu, 24 Jan 2002 18:20:26 +0530
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0195_01C1A503.CBE741E0
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
charset="iso-8859-1"
MessageYes, you can do that. Even you can open the links directly from
the table.
Manju
----- Original Message -----
From: Mark Brogan
To: Access ASP
Sent: Thursday, January 24, 2002 6:10 PM
Subject: [access_asp] RE: Regarding storing URL's in access2000
Following on from that can you make the links stored appear as links
when called from the database?
Mark
-----Original Message-----
From: manju_jacob [mailto:manju_jacob@m...]
Sent: 24 January 2002 04:41
To: Access ASP
Subject: [access_asp] Regarding storing URL's in access2000
I have a global.asa file in which connection to the ms access 2000db
is set
In access table I've a field which stores url of the files i have to
call in an asp page.
These url i'm storing as hyperlink..
Query is: Is it fine to store url's as hyperlinks? or should the
datatype be something else?
<% sql_findstud=3D"select * from stud"
Set RS_findstud=3DApplication("Conn").Execute(sql_findstud)
%>
The below syntax displays the fields cversion and ctitle in the HTML
page but curl is only not displayed...
<%=3DRS_findstud.Fields("cversion")%>
<%=3DRS_findstud.Fields("ctitle")%>
<a
href=3D<%=3DRS_findstud.Fields("curl")%>><%=3DRS_findstud.Fields("curl")%
></a>
Could Someone Help ME With this problem...
Regards,
Manju
$subst('Email.Unsub').
$subst('Email.Unsub').
------=_NextPart_000_0195_01C1A503.CBE741E0
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=3DContent-Type content=3D"text/html;
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4807.2300" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Yes, you can do that. Even you can open
the links
directly from the table.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Manju</FONT></DIV>
<BLOCKQUOTE
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px;
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color:
black"><B>From:</B>
<A title=3Dstmusicdude@j...
href=3D"mailto:stmusicdude@j...">Mark Brogan</A> </DIV>
<DIV style=3D"FONT: 10pt arial"><B>To:</B> <A
title=3Daccess_asp@p...
href=3D"mailto:access_asp@p...">Access ASP</A> </DIV>
<DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Thursday, January 24,
2002 6:10
PM</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Subject:</B> [access_asp] RE:
Regarding
storing URL's in access2000</DIV>
<DIV><BR></DIV>
<DIV><SPAN class=3D773443912-24012002><FONT face=3DArial
color=3D#0000ff
size=3D2>Following on from that can you make the links stored appear
as links
when called from the database?</FONT></SPAN></DIV>
<DIV><SPAN class=3D773443912-24012002><FONT face=3DArial
color=3D#0000ff
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D773443912-24012002><FONT face=3DArial
color=3D#0000ff
size=3D2>Mark</FONT></SPAN></DIV>
<BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr
align=3Dleft><FONT
face=3DTahoma size=3D2>-----Original Message-----<BR><B>From:</B>
manju_jacob
[mailto:manju_jacob@m...] <BR><B>Sent:</B> 24 January
2002
04:41<BR><B>To:</B> Access ASP<BR><B>Subject:</B> [access_asp]
Regarding
storing URL's in access2000<BR><BR></FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I have a global.asa file in which
connection to
the ms access 2000db is set</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>In access table I've
a field which
stores url of the files i have to call in an asp
page.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>These url i'm storing as
hyperlink..</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><U>Query is:</U> Is it
fine to
store url's as hyperlinks? or should the datatype be something
else?
</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2><% sql_findstud=3D"select * from
stud"</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Set
RS_findstud=3DApplication("Conn").Execute(sql_findstud)<BR>%></FONT></
DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>The below syntax displays the
fields cversion
and ctitle in the HTML page but curl is only not
displayed...</FONT></DIV>
<DIV><FONT face=3DArial
size=3D2><%=3DRS_findstud.Fields("cversion")%></FONT></DIV>
<DIV><FONT face=3DArial
size=3D2><%=3DRS_findstud.Fields("ctitle")%></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><a
href=3D<%=3DRS_findstud.Fields("curl")%>><%=3DRS_findstud.Fie
lds("curl")%></a></FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Could Someone Help ME With this
problem...</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Regards,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Manju</FONT></DIV>---<BR>Change
your mail
options at http://p2p.wrox.com/manager.asp or <BR>to unsubscribe
send a
blank email to $subst('Email.Unsub').
</BLOCKQUOTE>---<BR>
http://p2p.wrox.com/manager.asp or <BR>to unsubscribe send a blank
email to
$subst('Email.Unsub'). </BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_0195_01C1A503.CBE741E0--
|
|
|
View Cart
