Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_databases thread: Re: Accessing Word Documents


Message #1 by sanjeet1@h... on Wed, 3 Jul 2002 23:50:52
> HI

The page still does not load, I edited the code but I am still having 
problems.

<TD><A Href=3D<%3DRSSpeakersInfo("Location")%>View Detail</A></Td>



SANJEET
Message #2 by sanjeet1@h... on Wed, 3 Jul 2002 21:54:36
HI

Is it showing you  the error or it isnt showing the link at all .

+++The page is not even loading.
1) Are u getting the data from the database
+++Yes

2) If u can break the statement
do u give ur tag a name
The statment is on 1 line. What name am I supposed to give to what tag the 
Href?
This my block of code:

<% Do While Not RSSpeakersInfo.EOF %>
<TR CLASS=tbody align = center>
  <TD><%= RSSpeakersInfo("Seminar Date")%></TD>
  <TD><%= RSSpeakersInfo("SeminarTopic")%></TD>
  <TD><%= RSSpeakersInfo("SpeakerLast")%></TD>
  <TD><%= RSSpeakersInfo("Credits")%></TD>
  <TD><%Response.Write "<A Href = 'D:\Contract\Project" & RSSpeakersInfo
("Location") & ".doc'></a>"%></TD>


Thanks again in advance!!
<%Response.Write "<A Href =3D3D'D:\Contract\Project" & RSSpeakersInfo
("Location") & ".doc'">Link Name here </a>"%></TD>

Link needs a name try the link way
<a href=3D<%=3Drst(whatevervalue)%>link name here </a></td>

-----Original Message-----
From: sanjeet1@H... [mailto:sanjeet1@H...]
Sent: Wednesday, July 03, 2002 3:44 PM
To: ASP Databases
Subject: [asp_databases] Re: Accessing Word Documents


Hi,

I appreciate the response but I tried

<%Response.Write "<A Href =3D3D'D:\Contract\Project" & RSSpeakersInfo
("Location") & ".doc'"></a>"%></TD>

and it did not work. Where am I putting the apostrpohies wrong?

Thaks in advance!

> Try putting the href tag in place of option value hope that helps=3D20

thx
sid=3D20

-----Original Message-----
From: sanjeet1@h... [mailto:sanjeet1@h...]
Sent: Wednesday, July 03, 2002 2:18 PM
To: ASP Databases
Subject: [asp_databases] Re: Accessing Word Documents


> --0-1954053810-1025661203=3D3D:12195
Content-Type: text/plain; charset=3D3Dus-ascii

Hi guys

My web page calls the date,topic,credits,Location fields.
The View Detail field contains the word document corresponding to 
the=3D20
topic field. I typed in the location of where the document is sitting on 
=3D

my server but the link does not show up.

Here is my code:

'Response.Write "<Option Value=3D3D3D'D:\Contract\Project" & =3D
RSSpeakersInfo
("Location") & ".doc'>"%>

Sanjeet

Sanjeet,
Add one more field something like "FileName" to the database that has 
=3D
the=3D20
path and name of the document in it. The description link's HREF 
value=3D20
should be pointing to this FileName field's value. This will open up the 
=3D

word document in Explorer itself. Hope this helps you. Revert back if 
=3D
you=3D20
feel this is not sufficient.
All the best!!!
Regards,
Vijay.G
 sanjeet1@h... wrote:Hello,

I would appreciate it if someone could help me with this.

My site is connected to an access database. The database populates 
my=3D20
site. One of the columns populated is a description of a document. 
Once=3D20
this field is clicked a corresponding word document opens up.=3D20

Does anyone know how to do this?


Sanjeet
---
Change your mail options at http://p2p.wrox.com/manager.asp or=3D20


---------------------------------
Do You Yahoo!?
New! SBC Yahoo! Dial - 1st Month Free & unlimited access
---
Change your mail options at http://p2p.wrox.com/manager.asp or=3D20
to unsubscribe send a blank email to =3D
Message #3 by "Roy, Siddarth S" <sroy@b...> on Wed, 3 Jul 2002 14:58:35 -0400
Is it showing you  the error or it isnt showing the link at all .
1) Are u getting the data from the database
2) If u can break the statement
do u give ur tag a name

<%Response.Write "<A Href =3D3D'D:\Contract\Project" & RSSpeakersInfo
("Location") & ".doc'">Link Name here </a>"%></TD>

Link needs a name try the link way
<a href=3D<%=3Drst(whatevervalue)%>link name here </a></td>

-----Original Message-----
From: sanjeet1@H... [mailto:sanjeet1@H...]
Sent: Wednesday, July 03, 2002 3:44 PM
To: ASP Databases
Subject: [asp_databases] Re: Accessing Word Documents


Hi,

I appreciate the response but I tried

<%Response.Write "<A Href =3D3D'D:\Contract\Project" & RSSpeakersInfo
("Location") & ".doc'"></a>"%></TD>

and it did not work. Where am I putting the apostrpohies wrong?

Thaks in advance!

> Try putting the href tag in place of option value hope that helps=3D20

thx
sid=3D20

-----Original Message-----
From: sanjeet1@h... [mailto:sanjeet1@h...]
Sent: Wednesday, July 03, 2002 2:18 PM
To: ASP Databases
Subject: [asp_databases] Re: Accessing Word Documents


> --0-1954053810-1025661203=3D3D:12195
Content-Type: text/plain; charset=3D3Dus-ascii

Hi guys

My web page calls the date,topic,credits,Location fields.
The View Detail field contains the word document corresponding to 
the=3D20
topic field. I typed in the location of where the document is sitting on 
=3D

my server but the link does not show up.

Here is my code:

'Response.Write "<Option Value=3D3D3D'D:\Contract\Project" & =3D
RSSpeakersInfo
("Location") & ".doc'>"%>

Sanjeet

Sanjeet,
Add one more field something like "FileName" to the database that has 
=3D
the=3D20
path and name of the document in it. The description link's HREF 
value=3D20
should be pointing to this FileName field's value. This will open up the 
=3D

word document in Explorer itself. Hope this helps you. Revert back if 
=3D
you=3D20
feel this is not sufficient.
All the best!!!
Regards,
Vijay.G
 sanjeet1@h... wrote:Hello,

I would appreciate it if someone could help me with this.

My site is connected to an access database. The database populates 
my=3D20
site. One of the columns populated is a description of a document. 
Once=3D20
this field is clicked a corresponding word document opens up.=3D20

Does anyone know how to do this?


Sanjeet
---
Change your mail options at http://p2p.wrox.com/manager.asp or=3D20


---------------------------------
Do You Yahoo!?
New! SBC Yahoo! Dial - 1st Month Free & unlimited access
---
Change your mail options at http://p2p.wrox.com/manager.asp or=3D20
to unsubscribe send a blank email to =3D
Message #4 by sanjeet1@H... on Wed, 3 Jul 2002 19:43:47
Hi,

I appreciate the response but I tried 

<%Response.Write "<A Href =3D'D:\Contract\Project" & RSSpeakersInfo
("Location") & ".doc'"></a>"%></TD>

and it did not work. Where am I putting the apostrpohies wrong?

Thaks in advance!

> Try putting the href tag in place of option value hope that helps

thx
sid

-----Original Message-----
From: sanjeet1@h... [mailto:sanjeet1@h...]
Sent: Wednesday, July 03, 2002 2:18 PM
To: ASP Databases
Subject: [asp_databases] Re: Accessing Word Documents


> --0-1954053810-1025661203=3D:12195
Content-Type: text/plain; charset=3Dus-ascii

Hi guys

My web page calls the date,topic,credits,Location fields.
The View Detail field contains the word document corresponding to the
topic field. I typed in the location of where the document is sitting on 

my server but the link does not show up.

Here is my code:

'Response.Write "<Option Value=3D3D'D:\Contract\Project" & 
RSSpeakersInfo
("Location") & ".doc'>"%>

Sanjeet

Sanjeet,
Add one more field something like "FileName" to the database that has 
the
path and name of the document in it. The description link's HREF value
should be pointing to this FileName field's value. This will open up the 

word document in Explorer itself. Hope this helps you. Revert back if 
you
feel this is not sufficient.
All the best!!!
Regards,
Vijay.G
 sanjeet1@h... wrote:Hello,

I would appreciate it if someone could help me with this.

My site is connected to an access database. The database populates my
site. One of the columns populated is a description of a document. Once
this field is clicked a corresponding word document opens up.

Does anyone know how to do this?


Sanjeet


---------------------------------
Do You Yahoo!?
New! SBC Yahoo! Dial - 1st Month Free & unlimited access
Message #5 by "Roy, Siddarth S" <sroy@b...> on Wed, 3 Jul 2002 13:50:19 -0400
Try putting the href tag in place of option value hope that helps

thx
sid

-----Original Message-----
From: sanjeet1@h... [mailto:sanjeet1@h...]
Sent: Wednesday, July 03, 2002 2:18 PM
To: ASP Databases
Subject: [asp_databases] Re: Accessing Word Documents


> --0-1954053810-1025661203=3D:12195
Content-Type: text/plain; charset=3Dus-ascii

Hi guys

My web page calls the date,topic,credits,Location fields.
The View Detail field contains the word document corresponding to the
topic field. I typed in the location of where the document is sitting on 

my server but the link does not show up.

Here is my code:

'Response.Write "<Option Value=3D3D'D:\Contract\Project" & 
RSSpeakersInfo
("Location") & ".doc'>"%>

Sanjeet

Sanjeet,
Add one more field something like "FileName" to the database that has 
the
path and name of the document in it. The description link's HREF value
should be pointing to this FileName field's value. This will open up the 

word document in Explorer itself. Hope this helps you. Revert back if 
you
feel this is not sufficient.
All the best!!!
Regards,
Vijay.G
 sanjeet1@h... wrote:Hello,

I would appreciate it if someone could help me with this.

My site is connected to an access database. The database populates my
site. One of the columns populated is a description of a document. Once
this field is clicked a corresponding word document opens up.

Does anyone know how to do this?


Sanjeet


---------------------------------
Do You Yahoo!?
New! SBC Yahoo! Dial - 1st Month Free & unlimited access
Message #6 by sanjeet1@h... on Wed, 3 Jul 2002 18:18:22
> --0-1954053810-1025661203=:12195
Content-Type: text/plain; charset=us-ascii

Hi guys

My web page calls the date,topic,credits,Location fields.
The View Detail field contains the word document corresponding to the 
topic field. I typed in the location of where the document is sitting on 
my server but the link does not show up.

Here is my code:

'Response.Write "<Option Value=3D'D:\Contract\Project" & RSSpeakersInfo
("Location") & ".doc'>"%>

Sanjeet

Sanjeet,
Add one more field something like "FileName" to the database that has the 
path and name of the document in it. The description link's HREF value 
should be pointing to this FileName field's value. This will open up the 
word document in Explorer itself. Hope this helps you. Revert back if you 
feel this is not sufficient.
All the best!!!
Regards,
Vijay.G
 sanjeet1@h... wrote:Hello,

I would appreciate it if someone could help me with this.

My site is connected to an access database. The database populates my 
site. One of the columns populated is a description of a document. Once 
this field is clicked a corresponding word document opens up. 

Does anyone know how to do this?


Sanjeet


---------------------------------
Do You Yahoo!?
New! SBC Yahoo! Dial - 1st Month Free & unlimited access
Message #7 by "Drew, Ron" <RDrew@B...> on Wed, 3 Jul 2002 08:45:40 -0400
Response.write "<Option value=3D'xxxxx/" & rs("DocName") & ".doc'>"
Where xxxxx is the path for your document on your website

-----Original Message-----
From: sanjeet1@h... [mailto:sanjeet1@h...]
Sent: Tuesday, July 02, 2002 7:00 PM
To: ASP Databases
Subject: [asp_databases] Accessing Word Documents


Hello,

I would appreciate it if someone could help me with this.

My site is connected to an access database. The database populates my
site. One of the columns populated is a description of a document. Once
this field is clicked a corresponding word document opens up.

Does anyone know how to do this?


Sanjeet
Message #8 by Vijay G <happygv@y...> on Tue, 2 Jul 2002 18:53:23 -0700 (PDT)
--0-1954053810-1025661203=:12195
Content-Type: text/plain; charset=us-ascii


Sanjeet,
Add one more field something like "FileName" to the database that has the path and name of the document in it. The description
link's HREF value should be pointing to this FileName field's value. This will open up the word document in Explorer itself. Hope
this helps you. Revert back if you feel this is not sufficient.
All the best!!!
Regards,
Vijay.G
 sanjeet1@h... wrote:Hello,

I would appreciate it if someone could help me with this.

My site is connected to an access database. The database populates my 
site. One of the columns populated is a description of a document. Once 
this field is clicked a corresponding word document opens up. 

Does anyone know how to do this?


Sanjeet


---------------------------------
Do You Yahoo!?
New! SBC Yahoo! Dial - 1st Month Free & unlimited access
Message #9 by sanjeet1@h... on Tue, 2 Jul 2002 23:00:18
Hello,

I would appreciate it if someone could help me with this.

My site is connected to an access database. The database populates my 
site. One of the columns populated is a description of a document. Once 
this field is clicked a corresponding word document opens up. 

Does anyone know how to do this?


Sanjeet
Message #10 by "Drew, Ron" <RDrew@B...> on Thu, 11 Jul 2002 17:20:56 -0400
<TD><a href=3D"<%RSSpeakersInfo("Location")%>"View Detail</A></TD>
Add quotes to the href

-----Original Message-----
From: sanjeet1@h... [mailto:sanjeet1@h...]
Sent: Thursday, July 11, 2002 5:49 PM
To: ASP Databases
Subject: [asp_databases] Re: Accessing Word Documents


Hello I still have problems making this work.


Does anyone know how to do this.

> The page still does not load, I edited the code but I am still having
p> roblems.

> <TD><A Href=3D3D<%3DRSSpeakersInfo("Location")%>View Detail</A></Td>

>

> SANJEET
Message #11 by "Peter Foti (PeterF)" <PeterF@S...> on Thu, 11 Jul 2002 16:54:55 -0400
Try fixing your <a> tag by surrounding the href value in quotes.  Also, is
"3D" a part of the href value?  Also, you are missing the = sign after the
<%.

<a href="3D<%= 3DRSSpeakersInfo("Location") %>">View Detail</a>
         ^^    ^^

I suspect this is probably the correct solution:

<a href="<%= RSSpeakersInfo("Location") %>">View Detail</a>
 

Regards,
Peter

> -----Original Message-----
> From: sanjeet1@h... [mailto:sanjeet1@h...]
> Sent: Thursday, July 11, 2002 9:49 PM
> To: ASP Databases
> Subject: [asp_databases] Re: Accessing Word Documents
> 
> 
> Hello I still have problems making this work.
> 
> 
> Does anyone know how to do this.
> 
> > The page still does not load, I edited the code but I am 
> still having 
> p> roblems.
> 
> > <TD><A Href=3D<%3DRSSpeakersInfo("Location")%>View Detail</A></Td>
> 
> > 
> 
> > SANJEET
> 
Message #12 by "Varghese, Biju (ZB4214)" <Biju.Varghese@p...> on Thu, 11 Jul 2002 13:42:30 -0700
Try putting an "=" inside the script.
<%=3DRSSpeakersInfo("Location")%>


-----Original Message-----
From: sanjeet1@h... [mailto:sanjeet1@h...]
Sent: Thursday, July 11, 2002 2:49 PM
To: ASP Databases
Subject: [asp_databases] Re: Accessing Word Documents


Hello I still have problems making this work.


Does anyone know how to do this.

> The page still does not load, I edited the code but I am still having 
p> roblems.

> <TD><A Href=3D<%3DRSSpeakersInfo("Location")%>View Detail</A></Td>

> 

> SANJEET

Message #13 by sanjeet1@h... on Thu, 11 Jul 2002 21:48:36
Hello I still have problems making this work.


Does anyone know how to do this.

> The page still does not load, I edited the code but I am still having 
p> roblems.

> <TD><A Href=3D<%3DRSSpeakersInfo("Location")%>View Detail</A></Td>

> 

> SANJEET

  Return to Index