Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_web_howto thread: RE: asp_web_howto digest: November 19, 2001


Message #1 by "Rainery, Kim" <Kim.Rainery@w...> on Tue, 20 Nov 2001 09:57:20 -0600
Hi



I am wondering if anyone has ever done something with javascript where they

have two radio buttons and some checkboxes, the checkboxes are associated

with only one radio button and if someone checks the checkboxes the

associated radio should automatically become selected? any help would be

appreciated.

thanks

Kim



-----Original Message-----

From: ASP Web HowTo digest [mailto:asp_web_howto@p...]

Sent: Monday, November 19, 2001 6:01 PM

To: asp_web_howto digest recipients

Subject: asp_web_howto digest: November 19, 2001





-----------------------------------------------

When replying to the digest, please quote only

relevant material, and edit the subject line to

reflect the message you are replying to.

-----------------------------------------------



ASP_WEB_HOWTO Digest for Monday, November 19, 2001.



1. Re: Links

2. Re: Links

3. Re: Links

4. Re: cookies

5. Re: cookies

6. Re: cookies

7. Re: cookies

8. Re: cookies

9. Help with a query

10. Re: cookies

11. Re: Help with a query

12. Re: File Download code

13. Re: Help with a query

14. Re: Help with a query

15. Error invoking Crystal Reports from ASP using Netscape

16. Re: Help with a query

17. Re: Help with a query

18. Problem with using JScript and VBScript in One File

19. RE: Problem with using JScript and VBScript in On-     e File

20. RE: Problem with using JScript and VBScript i-     n On e File

21. RE: Problem with using JScript and VBScript i-      n On e File

22. RE: Problem with using JScript and VBScript in On-     e File

23. RE: Problem with using JScript and VBScript i-      n On e File

24. RE: Problem with using JScript and VBScript i-      n On e File

25. RE: Problem with using JScript and VBScript i-      n On e File

26. Re: new window

27. Re: new window

28. Re: Generating doc files from ASP

29. Re: Links

30. Re: Links

31. Re: Problem with using JScript and VBScript in One File

32. RE: Problem with using JScript and VBScript i     n On e File

33. Re: new window



----------------------------------------------------------------------



Subject: Re: Links

From: "Jason Salas" <jason@k...>

Date: Mon, 19 Nov 2001 09:52:31 +1000

X-Message-Number: 1



Hi John,



When people do things like "filename.asp?id=23" they are typically

connecting to a database and displaying the results of a specific record in

the DB which is called when a user does something, like clicking on a

hyperlink.  The number is usually the unique key identifier for the record.



In the code, this is assigned dynamically by writing the SQL statement

on-the-fly.  An example of this would be:



Dim id, strSQL

strSQL = "SELECT * FROM tableName WHERE id = '" & id & "'"



...this would call upon a precice value for the "id" (again, typically the

unique key in a DB table) and then bring up that record.



HTH,

Jason









----- Original Message -----

From: "John Tarbell" <kmind711@a...>

To: "ASP Web HowTo" <asp_web_howto@p...>

Sent: Sunday, November 18, 2001 11:47 PM

Subject: [asp_web_howto] Re: Links





>> OK, i understand how to do the code with like the first name and last

name

> but i see on the links how it says like ?id=23 or whatever and when i go

> to the page it has a lot of things on the page but it never says like that

> the id=23 on the page. How is this done?







----------------------------------------------------------------------



Subject: Re: Links

From: "Daniel O'Dorisio" <daniel@o...>

Date: Sun, 18 Nov 2001 19:05:38 -0500

X-Message-Number: 2



have you studied any?? go get a book on asp.. beginning asp 3.0 is a good

one.. it will let you in on all the secrets:-)



daniel



--

-----------------------------

Daniel O'Dorisio

daniel@o...

www.odorisio-networks.com

-----------------------------

"John Tarbell" <kmind711@a...> wrote in message

news:120898@a..._web_howto...

>

> > The other are right...any characters starting with a question mark in a

> > URL are a QUERYSTRING.  The easiest way to put values into the

> querystring

> > would be to do so from a posting a form with the "GET" method set in the

> > ACTION attribute of the HTML <form> tag.  For example, using the

> following

> > two pages will produce the folllowing URL:

> >

> > page2.asp?FIRSTNAME=jason&LASTNAME=salas

> >

> > ************* PAGE1.ASP *******************

> > <html><body>

> > <form action="page2.asp" metod="get">

> > <input type="text" name="FIRSTNAME"><br>

> > Enter your first name:<p>

> > <input type="text" name="LASTNAME"><br>

> > Enter your last name:<p>

> > <input type="submit" name="SUBMIT">

> > </body></html>

> >

>

> OK, i understand how to do the code with like the first name and last name

> but i see on the links how it says like ?id=23 or whatever and when i go

> to the page it has a lot of things on the page but it never says like that

> the id=23 on the page. How is this done?

> > ************* PAGE2.ASP *******************

> > <% @ Language=VBScript %>

> >

> > <%

> > Dim first, last

> > first = Request.QueryString("FIRSTNAME")

> > last = Request.QueryString("LASTNAME")

> >

> > Response.Write "This is the data you entered: " & first & " " & last

> >

> > %>

> >

> > At higher levels, ASP developers use querystrings to pass values stored

> in

> > databases, for things like publishing in e-commerce.

> >

> > HTH,

> > Jason

> >

> > ---------------------------------------------------

> >  Jason Salas, MBA, MCP

> >  Web Development Manager

> >  Pacific Telestations, Inc. (dba, "KUAM")

> >

> >

> >

> > > Hello, I am new at .asp and I have seen sites with links for example

> > > like "http://www.blah.com/sport?id=23" and I was just wondering how

> you

> > > put the "?id=23" in there (like do you have to put something special

> on

> > a

> > > different page)?

> > >

> > > Thanks and I hope I get some responses b/c I really need to know

> how!!!

> > =)

>

>







----------------------------------------------------------------------



Subject: Re: Links

From: "Daniel O'Dorisio" <daniel@o...>

Date: Sun, 18 Nov 2001 19:21:17 -0500

X-Message-Number: 3



one other thing to try.. search google for using querystrings in asp:

http://www.google.com/search?hl=en&q=using+querystrings+in+asp

(watch wrapping)



daniel



--

-----------------------------

Daniel O'Dorisio

daniel@o...

www.odorisio-networks.com

-----------------------------

"John Tarbell" <kmind711@a...> wrote in message

news:120898@a..._web_howto...

>

> > The other are right...any characters starting with a question mark in a

> > URL are a QUERYSTRING.  The easiest way to put values into the

> querystring

> > would be to do so from a posting a form with the "GET" method set in the

> > ACTION attribute of the HTML <form> tag.  For example, using the

> following

> > two pages will produce the folllowing URL:

> >

> > page2.asp?FIRSTNAME=jason&LASTNAME=salas

> >

> > ************* PAGE1.ASP *******************

> > <html><body>

> > <form action="page2.asp" metod="get">

> > <input type="text" name="FIRSTNAME"><br>

> > Enter your first name:<p>

> > <input type="text" name="LASTNAME"><br>

> > Enter your last name:<p>

> > <input type="submit" name="SUBMIT">

> > </body></html>

> >

>

> OK, i understand how to do the code with like the first name and last name

> but i see on the links how it says like ?id=23 or whatever and when i go

> to the page it has a lot of things on the page but it never says like that

> the id=23 on the page. How is this done?

> > ************* PAGE2.ASP *******************

> > <% @ Language=VBScript %>

> >

> > <%

> > Dim first, last

> > first = Request.QueryString("FIRSTNAME")

> > last = Request.QueryString("LASTNAME")

> >

> > Response.Write "This is the data you entered: " & first & " " & last

> >

> > %>

> >

> > At higher levels, ASP developers use querystrings to pass values stored

> in

> > databases, for things like publishing in e-commerce.

> >

> > HTH,

> > Jason

> >

> > ---------------------------------------------------

> >  Jason Salas, MBA, MCP

> >  Web Development Manager

> >  Pacific Telestations, Inc. (dba, "KUAM")

> >

> >

> >

> > > Hello, I am new at .asp and I have seen sites with links for example

> > > like "http://www.blah.com/sport?id=23" and I was just wondering how

> you

> > > put the "?id=23" in there (like do you have to put something special

> on

> > a

> > > different page)?

> > >

> > > Thanks and I hope I get some responses b/c I really need to know

> how!!!

> > =)

>

>







----------------------------------------------------------------------



Subject: Re: cookies

From: "Ken Schaefer" <ken@a...>

Date: Mon, 19 Nov 2001 11:31:14 +1100

X-Message-Number: 4



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: "Daniel O'Dorisio" <daniel@o...>

Sent: Saturday, November 17, 2001 2:48 AM

Subject: [asp_web_howto] Re: cookies





: i would have to argue that point..

:

: by design cookies are only accessable by the domain

: that creates them..

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~



IIRC - a cookie can only be read by the domain that it is *set to*



So foo.com can set a cookie for bar.com which means that bar.com can read

it, but foo.com can not.

Alternatively, foo.com can set a cookie for foo.com, which can be read by

foo.com, but not bar.com



Cheers

Ken





----------------------------------------------------------------------



Subject: Re: cookies

From: "Daniel O'Dorisio" <daniel@o...>

Date: Sun, 18 Nov 2001 19:51:48 -0500

X-Message-Number: 5



yes you are correct.. my apalogies.. i should have clarified..



thanks!

daniel



--

-----------------------------

Daniel O'Dorisio

daniel@o...

www.odorisio-networks.com

-----------------------------

"Ken Schaefer" <ken@a...> wrote in message

news:120912@a..._web_howto...

>

> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

> From: "Daniel O'Dorisio" <daniel@o...>

> Sent: Saturday, November 17, 2001 2:48 AM

> Subject: [asp_web_howto] Re: cookies

>

>

> : i would have to argue that point..

> :

> : by design cookies are only accessable by the domain

> : that creates them..

> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

>

> IIRC - a cookie can only be read by the domain that it is *set to*

>

> So foo.com can set a cookie for bar.com which means that bar.com can read

> it, but foo.com can not.

> Alternatively, foo.com can set a cookie for foo.com, which can be read by

> foo.com, but not bar.com

>

> Cheers

> Ken

>

>

>







----------------------------------------------------------------------



Subject: Re: cookies

From: "Daniel O'Dorisio" <daniel@o...>

Date: Sun, 18 Nov 2001 22:12:03 -0500

X-Message-Number: 6



ken..

hmm.. well after i sent that last email.. i said.. hmm.. this is wierd.. so

im going to do more studying on it... and i think i am going to have to say

that this wont work.. you can only set a cookie for the domain on wich the

page resides... (i should have thought of this before sending the last

email)

------------------------

> IIRC - a cookie can only be read by the domain that it is *set to*

>

> So foo.com can set a cookie for bar.com which means that bar.com can read

> it, but foo.com can not.

> Alternatively, foo.com can set a cookie for foo.com, which can be read by

> foo.com, but not bar.com

------------------------

i agree with the fact that you can only read a cookie on the domain of which

matches the domain value of that cookie.. but the other thing is.. you can

only set a cookie if the domain matches the value you are trying to set it

to with exceptions to subdomains. so in effect.. you can only read cookies

that were created on that domain.. from what i have found.. here is my

research.. with a conclusion at the end:





according to cookie central they say that this cant be done

http://www.cookiecentral.com/faq/#4.7 no big deal.. taht is cookie central..



but then i go to the RFC 2109 on http state management(cookies) i get this:

(section 4.3.2)



<quote>

To prevent possible security or privacy violations, a user agent

   rejects a cookie (shall not store its information) if any of the

   following is true:



   * The value for the Path attribute is not a prefix of the request-

     URI.



   * The value for the Domain attribute contains no embedded dots or

     does not start with a dot.



   * The value for the request-host does not domain-match the Domain

     attribute.



   * The request-host is a FQDN (not IP address) and has the form HD,

     where D is the value of the Domain attribute, and H is a string

     that contains one or more dots.

</quote>



i kept searching since that rfc is dated.. and found this at

http://www.simplythebest.net/info/cookieinfo.html:



<quote>

domain=DOMAIN_NAME

When searching the cookie list for valid cookies, a comparison of the domain

attributes of the cookie is made with the Internet domain name of the host

from which the URL will be fetched. If there is a tail match, then the

cookie will go through path matching to see if it should be sent. "Tail

matching" means that domain attribute is matched against the tail of the

fully qualified domain name of the host. A domain attribute of "me.com"

would match host names "yes.me.com" as well as "yes.no.me.com".

Only hosts within the specified domain can set a cookie for a domain and

domains must have at least two (2) or three (3) periods in them to prevent

domains of the form: ".com", ".edu", and "va.us". Any domain that fails

within one of the seven special top level domains listed below only require

two periods. Any other domain requires at least three. The seven special top

level domains are: "COM", "EDU", "NET", "ORG", "GOV", "MIL" and "INT". The

default value of domain is the host name of the server which generated the

cookie response.



</quote>



i kept looking and found this in RFC 2965 which is dated october of 2000

(http://www.ietf.org/rfc/rfc2965.txt section 3.3.2)



<quote>

Moreover, a user agent rejects (SHALL NOT

   store its information) if any of the following is true of the

   attributes explicitly present in the Set-Cookie2 response header:



      *  The value for the Path attribute is not a prefix of the

         request-URI.



      *  The value for the Domain attribute contains no embedded dots,

         and the value is not .local.



      *  The effective host name that derives from the request-host does

         not domain-match the Domain attribute.



      *  The request-host is a HDN (not IP address) and has the form HD,

         where D is the value of the Domain attribute, and H is a string

         that contains one or more dots.



      *  The Port attribute has a "port-list", and the request-port was

         not in the list.





</quote>

according to STD1 this is the current reccommendation..



so then this brings me to this conclusion:

cookies can be set to only the domain on wich that page resides. should the

page try to set a cookie for xyz.com and it resides on abc.com the user

agent will disregard that cookie due to the request-host, and daomin

attributes do not match up.



maybe i have missed something.. i would love to know.. if you see some error

in what i have found let me know.. but for now (unless i get another email

tonight) i am going to try to get some other stuff done..



daniel



--

-----------------------------

Daniel O'Dorisio

daniel@o...

www.odorisio-networks.com

-----------------------------

"Ken Schaefer" <ken@a...> wrote in message

news:120912@a..._web_howto...

>

> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

> From: "Daniel O'Dorisio" <daniel@o...>

> Sent: Saturday, November 17, 2001 2:48 AM

> Subject: [asp_web_howto] Re: cookies

>

>

> : i would have to argue that point..

> :

> : by design cookies are only accessable by the domain

> : that creates them..

> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

>

> IIRC - a cookie can only be read by the domain that it is *set to*

>

> So foo.com can set a cookie for bar.com which means that bar.com can read

> it, but foo.com can not.

> Alternatively, foo.com can set a cookie for foo.com, which can be read by

> foo.com, but not bar.com

>

> Cheers

> Ken

>

>

>







----------------------------------------------------------------------



Subject: Re: cookies

From: "Ken Schaefer" <ken@a...>

Date: Mon, 19 Nov 2001 14:42:29 +1100

X-Message-Number: 7



Since my previous post, I've also been reading:

http://www.ietf.org/rfc/rfc2109.txt

which indicates that the Request-Host (originating server) can only set a

cookie for the domain it is part of - I was reading the wrong part (the bit

where it says that the receving server will only accept a cookie that

matches the domain that the receiving server is part of).



Of course, the above is no means definitive of real world behaviour as

cookies where originally developed by Netscape, and thus there is no

definitive standard that everybody follows...but it appears that I was

incorrect previously. Thanks for the info.



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: "Daniel O'Dorisio" <daniel@o...>

Subject: [asp_web_howto] Re: cookies





: ken..

: hmm.. well after i sent that last email.. i said.. hmm.. this is wierd..

so

: im going to do more studying on it... and i think i am going to have to

say

: that this wont work.. you can only set a cookie for the domain on wich the

: page resides... (i should have thought of this before sending the last

: email)

: ------------------------

: > IIRC - a cookie can only be read by the domain that it is *set to*

: >

: > So foo.com can set a cookie for bar.com which means that bar.com can

read

: > it, but foo.com can not.

: > Alternatively, foo.com can set a cookie for foo.com, which can be read

by

: > foo.com, but not bar.com

: ------------------------

: i agree with the fact that you can only read a cookie on the domain of

which

: matches the domain value of that cookie.. but the other thing is.. you can

: only set a cookie if the domain matches the value you are trying to set it

: to with exceptions to subdomains. so in effect.. you can only read cookies

: that were created on that domain.. from what i have found.. here is my

: research.. with a conclusion at the end:

:

:

: according to cookie central they say that this cant be done

: http://www.cookiecentral.com/faq/#4.7 no big deal.. taht is cookie

central..

:

: but then i go to the RFC 2109 on http state management(cookies) i get

this:

: (section 4.3.2)







----------------------------------------------------------------------



Subject: Re: cookies

From: "Daniel O'Dorisio" <daniel@o...>

Date: Sun, 18 Nov 2001 22:38:13 -0500

X-Message-Number: 8



thank you for the info.. i would probally not have gone in more depth had

you not sent that email.. thanks!



daniel



--

-----------------------------

Daniel O'Dorisio

daniel@o...

www.odorisio-networks.com

-----------------------------

"Ken Schaefer" <ken@a...> wrote in message

news:120932@a..._web_howto...

>

> Since my previous post, I've also been reading:

> http://www.ietf.org/rfc/rfc2109.txt

> which indicates that the Request-Host (originating server) can only set a

> cookie for the domain it is part of - I was reading the wrong part (the

bit

> where it says that the receving server will only accept a cookie that

> matches the domain that the receiving server is part of).

>

> Of course, the above is no means definitive of real world behaviour as

> cookies where originally developed by Netscape, and thus there is no

> definitive standard that everybody follows...but it appears that I was

> incorrect previously. Thanks for the info.

>

> Cheers

> Ken

>

> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

> From: "Daniel O'Dorisio" <daniel@o...>

> Subject: [asp_web_howto] Re: cookies

>

>

> : ken..

> : hmm.. well after i sent that last email.. i said.. hmm.. this is wierd..

> so

> : im going to do more studying on it... and i think i am going to have to

> say

> : that this wont work.. you can only set a cookie for the domain on wich

the

> : page resides... (i should have thought of this before sending the last

> : email)

> : ------------------------

> : > IIRC - a cookie can only be read by the domain that it is *set to*

> : >

> : > So foo.com can set a cookie for bar.com which means that bar.com can

> read

> : > it, but foo.com can not.

> : > Alternatively, foo.com can set a cookie for foo.com, which can be read

> by

> : > foo.com, but not bar.com

> : ------------------------

> : i agree with the fact that you can only read a cookie on the domain of

> which

> : matches the domain value of that cookie.. but the other thing is.. you

can

> : only set a cookie if the domain matches the value you are trying to set

it

> : to with exceptions to subdomains. so in effect.. you can only read

cookies

> : that were created on that domain.. from what i have found.. here is my

> : research.. with a conclusion at the end:

> :

> :

> : according to cookie central they say that this cant be done

> : http://www.cookiecentral.com/faq/#4.7 no big deal.. taht is cookie

> central..

> :

> : but then i go to the RFC 2109 on http state management(cookies) i get

> this:

> : (section 4.3.2)

>

>

>

>







----------------------------------------------------------------------



Subject: Help with a query

From: "O'Hara, Elliott M" <EMOHARA@k...>

Date: Mon, 19 Nov 2001 06:59:28 -0500

X-Message-Number: 9



OK... I know there has to be a way to do this..

But its early and I can't think of it...



I've got 2 separate Employee Databases and I only want one. I've altered the

tables on the one I want to keep to contain the columns that the db to be

discarded has.



now... I want to make a update query that first pulls the BEMSID column from

DB 1 (gunna die) and inserts it into the charBEMSID column in the DB 2 (not

gunna die) WHERE the DB1.Lastname = DB2.Lastname and

DB1.FirstName=DB2.FirstName



something like



UPDATE tblEmployees

SET charBEMSID = (SELECT Server.Database.dbo.table.BEMSID FROM

Server.Database.dbo.table WHERE LastName = I AM LOST HERE)

WHERE LastName = LOST HERE TOO



any ideas???



Does that make any since?



Thanks,

Elliott



----------------------------------------------------------------------



Subject: Re: cookies

From: "Morgan, Rob" <Rob.Morgan@o...>

Date: Mon, 19 Nov 2001 07:15:27 -0500

X-Message-Number: 10



Thanks for all the info..



I did some research on the topic also and found that a cookie can be read by

all webservers as long as they have the same sub domain name.  The domain

attibute can use for a sub domain as long as two periods are used. I was

able to set the domain on the cookie to .ode.state.oh.us and then any web

server in my domain could read the cookie info.



Here are a few nice articles on the subject.



http://www.softartisans.com/softartisans/techfour.html

http://www.asp101.com/articles/chris/transfercookies/default.asp

http://www.zdnet.com/devhead/stories/articles/0,4413,2614768,00.html





Thanks

Rob



-----Original Message-----

From: Daniel O'Dorisio [mailto:daniel@o...]

Sent: Sunday, November 18, 2001 10:38 PM

To: ASP Web HowTo

Subject: [asp_web_howto] Re: cookies





thank you for the info.. i would probally not have gone in more depth had

you not sent that email.. thanks!



daniel



--

-----------------------------

Daniel O'Dorisio

daniel@o...

www.odorisio-networks.com

-----------------------------

"Ken Schaefer" <ken@a...> wrote in message

news:120932@a..._web_howto...

>

> Since my previous post, I've also been reading:

> http://www.ietf.org/rfc/rfc2109.txt

> which indicates that the Request-Host (originating server) can only set a

> cookie for the domain it is part of - I was reading the wrong part (the

bit

> where it says that the receving server will only accept a cookie that

> matches the domain that the receiving server is part of).

>

> Of course, the above is no means definitive of real world behaviour as

> cookies where originally developed by Netscape, and thus there is no

> definitive standard that everybody follows...but it appears that I was

> incorrect previously. Thanks for the info.

>

> Cheers

> Ken

>

> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

> From: "Daniel O'Dorisio" <daniel@o...>

> Subject: [asp_web_howto] Re: cookies

>

>

> : ken..

> : hmm.. well after i sent that last email.. i said.. hmm.. this is wierd..

> so

> : im going to do more studying on it... and i think i am going to have to

> say

> : that this wont work.. you can only set a cookie for the domain on wich

the

> : page resides... (i should have thought of this before sending the last

> : email)

> : ------------------------

> : > IIRC - a cookie can only be read by the domain that it is *set to*

> : >

> : > So foo.com can set a cookie for bar.com which means that bar.com can

> read

> : > it, but foo.com can not.

> : > Alternatively, foo.com can set a cookie for foo.com, which can be read

> by

> : > foo.com, but not bar.com

> : ------------------------

> : i agree with the fact that you can only read a cookie on the domain of

> which

> : matches the domain value of that cookie.. but the other thing is.. you

can

> : only set a cookie if the domain matches the value you are trying to set

it

> : to with exceptions to subdomains. so in effect.. you can only read

cookies

> : that were created on that domain.. from what i have found.. here is my

> : research.. with a conclusion at the end:

> :

> :

> : according to cookie central they say that this cant be done

> : http://www.cookiecentral.com/faq/#4.7 no big deal.. taht is cookie

> central..

> :

> : but then i go to the RFC 2109 on http state management(cookies) i get

> this:

> : (section 4.3.2)

>

>

>

>










$subst('Email.Unsub')



----------------------------------------------------------------------



Subject: Re: Help with a query

From:   "Serge Wagemakers" <swagemakers@d...>

Date:   Mon, 19 Nov 2001 13:54:57 +0100

X-Message-Number: 11



Depends on the database server you're using to figure out the query.

The way to go is to use a distributed query to get info from a table at db1

and

insert it into a table in db2.



In informix it's something like:



SELECT O.order_num, C.fname, C.lname

 FROM masterdb@c...:customer C, sales@b...:orders O

 WHERE C.customer_num = O.Customer_num



In Access I believe you have to have MS Transaction Server for using

distributed

queries.



HTH,



Serge

----- Original Message -----

From: "O'Hara, Elliott M" <EMOHARA@k...>

To: "ASP Web HowTo" <asp_web_howto@p...>

Sent: Monday, November 19, 2001 12:59 PM

Subject: [asp_web_howto] Help with a query





> OK... I know there has to be a way to do this..

> But its early and I can't think of it...

>

> I've got 2 separate Employee Databases and I only want one. I've altered

the

> tables on the one I want to keep to contain the columns that the db to be

> discarded has.

>

> now... I want to make a update query that first pulls the BEMSID column

from

> DB 1 (gunna die) and inserts it into the charBEMSID column in the DB 2

(not

> gunna die) WHERE the DB1.Lastname = DB2.Lastname and

> DB1.FirstName=DB2.FirstName

>

> something like

>

> UPDATE tblEmployees

> SET charBEMSID = (SELECT Server.Database.dbo.table.BEMSID FROM

> Server.Database.dbo.table WHERE LastName = I AM LOST HERE)

> WHERE LastName = LOST HERE TOO

>

> any ideas???

>

> Does that make any since?

>

> Thanks,

> Elliott

>




$subst('Email.Unsub')

>





----------------------------------------------------------------------



Subject: Re: File Download code

From: "Yuri Mikailkof" <3ahoceh@m...>

Date: Mon, 19 Nov 2001 13:56:16

X-Message-Number: 12



> How does one send a different MIME type to force the download? 

> My assumption is that the code:

>   <a href="myword.doc">Download</a>

>  would open the file

> 

> I apoligize if my questions seem simple, but I'm new to this. 

> 

> -----Original Message-----

> From: Greg Griffiths [mailto:griffiths@x...]

> Sent: Friday, October 05, 2001 2:39 PM

> To: ASP Web HowTo

> Subject: [asp_web_howto] Re: File Download code

> 

> 

> <a href="myword.doc">Download</a>

> 

> What happens when the user clicks on it depends on their MIME 

configuration 

> on the client machine , the only ay to get around this is to send a 

> different MIME type which will force the save as menu.

> 

> At 09:41 05/10/01 -0400, you wrote:

> 

> >Can anyone point me to code that can be used to download either a word 

or

> >.pdf file from an asp page.

> >

> >Timothy S. Brooks

> >tbrooks@c... <mailto:tbrooks@c...>

> >

> >ext. 365

----------------------------------------------------------------------



Subject: Re: Help with a query

From:   "Michiel van Otegem \(lists ONLY\)" <michiel_lists@a...>

Date:   Mon, 19 Nov 2001 15:29:11 +0100

X-Message-Number: 13



In Access you can't do distributed queries, unless you have a link in DBx to

the tables in DBy. Transaction server won't help one bit, because it enlists

the Distributed Transaction Coordinator for database stuff... only one tiny

little problem... DTC can't talk properly to Access.



---

Michiel van Otegem

ASPNL.com    - ASP/ASP.NET/XML Teacher

ASPFriends.com - Moderator



http://www.aspnl.com

http://www.aspalliance.com/michiel

off-list email: michiel@a...

---

----- Original Message -----

From: "Serge Wagemakers" <swagemakers@d...>

To: "ASP Web HowTo" <asp_web_howto@p...>

Sent: Monday, November 19, 2001 1:54 PM

Subject: [asp_web_howto] Re: Help with a query





> Depends on the database server you're using to figure out the query.

> The way to go is to use a distributed query to get info from a table at

db1

> and

> insert it into a table in db2.

>

> In informix it's something like:

>

> SELECT O.order_num, C.fname, C.lname

>  FROM masterdb@c...:customer C, sales@b...:orders O

>  WHERE C.customer_num = O.Customer_num

>

> In Access I believe you have to have MS Transaction Server for using

> distributed

> queries.

>

> HTH,

>

> Serge

> ----- Original Message -----

> From: "O'Hara, Elliott M" <EMOHARA@k...>

> To: "ASP Web HowTo" <asp_web_howto@p...>

> Sent: Monday, November 19, 2001 12:59 PM

> Subject: [asp_web_howto] Help with a query

>

>

> > OK... I know there has to be a way to do this..

> > But its early and I can't think of it...

> >

> > I've got 2 separate Employee Databases and I only want one. I've altered

> the

> > tables on the one I want to keep to contain the columns that the db to

be

> > discarded has.

> >

> > now... I want to make a update query that first pulls the BEMSID column

> from

> > DB 1 (gunna die) and inserts it into the charBEMSID column in the DB 2

> (not

> > gunna die) WHERE the DB1.Lastname = DB2.Lastname and

> > DB1.FirstName=DB2.FirstName

> >

> > something like

> >

> > UPDATE tblEmployees

> > SET charBEMSID = (SELECT Server.Database.dbo.table.BEMSID FROM

> > Server.Database.dbo.table WHERE LastName = I AM LOST HERE)

> > WHERE LastName = LOST HERE TOO

> >

> > any ideas???

> >

> > Does that make any since?

> >

> > Thanks,

> > Elliott

> >




> $subst('Email.Unsub')

> >

>

>




$subst('Email.Unsub')

>

>





----------------------------------------------------------------------



Subject: Re: Help with a query

From:   "Serge Wagemakers" <swagemakers@d...>

Date:   Mon, 19 Nov 2001 15:55:12 +0100

X-Message-Number: 14



Thanks for correcting me... After I posted it, it occured to me as well

Access is not the

server to do distributed queries with... Sorry about that!



----- Original Message -----

From: "Michiel van Otegem (lists ONLY)" <michiel_lists@a...>

To: "ASP Web HowTo" <asp_web_howto@p...>

Sent: Monday, November 19, 2001 3:29 PM

Subject: [asp_web_howto] Re: Help with a query





> In Access you can't do distributed queries, unless you have a link in DBx

to

> the tables in DBy. Transaction server won't help one bit, because it

enlists

> the Distributed Transaction Coordinator for database stuff... only one

tiny

> little problem... DTC can't talk properly to Access.

>

> ---

> Michiel van Otegem

> ASPNL.com    - ASP/ASP.NET/XML Teacher

> ASPFriends.com - Moderator

>

> http://www.aspnl.com

> http://www.aspalliance.com/michiel

> off-list email: michiel@a...

> ---

> ----- Original Message -----

> From: "Serge Wagemakers" <swagemakers@d...>

> To: "ASP Web HowTo" <asp_web_howto@p...>

> Sent: Monday, November 19, 2001 1:54 PM

> Subject: [asp_web_howto] Re: Help with a query

>

>

> > Depends on the database server you're using to figure out the query.

> > The way to go is to use a distributed query to get info from a table at

> db1

> > and

> > insert it into a table in db2.

> >

> > In informix it's something like:

> >

> > SELECT O.order_num, C.fname, C.lname

> >  FROM masterdb@c...:customer C, sales@b...:orders O

> >  WHERE C.customer_num = O.Customer_num

> >

> > In Access I believe you have to have MS Transaction Server for using

> > distributed

> > queries.

> >

> > HTH,

> >

> > Serge

> > ----- Original Message -----

> > From: "O'Hara, Elliott M" <EMOHARA@k...>

> > To: "ASP Web HowTo" <asp_web_howto@p...>

> > Sent: Monday, November 19, 2001 12:59 PM

> > Subject: [asp_web_howto] Help with a query

> >

> >

> > > OK... I know there has to be a way to do this..

> > > But its early and I can't think of it...

> > >

> > > I've got 2 separate Employee Databases and I only want one. I've

altered

> > the

> > > tables on the one I want to keep to contain the columns that the db to

> be

> > > discarded has.

> > >

> > > now... I want to make a update query that first pulls the BEMSID

column

> > from

> > > DB 1 (gunna die) and inserts it into the charBEMSID column in the DB 2

> > (not

> > > gunna die) WHERE the DB1.Lastname = DB2.Lastname and

> > > DB1.FirstName=DB2.FirstName

> > >

> > > something like

> > >

> > > UPDATE tblEmployees

> > > SET charBEMSID = (SELECT Server.Database.dbo.table.BEMSID FROM

> > > Server.Database.dbo.table WHERE LastName = I AM LOST HERE)

> > > WHERE LastName = LOST HERE TOO

> > >

> > > any ideas???

> > >

> > > Does that make any since?

> > >

> > > Thanks,

> > > Elliott

> > >




> > $subst('Email.Unsub')

> > >

> >

> >



michiel_lists@a...


> $subst('Email.Unsub')

> >

> >

>

>




$subst('Email.Unsub')

>





----------------------------------------------------------------------



Subject: Error invoking Crystal Reports from ASP using Netscape

From: "Kathy Egan" <kathy.egan@h...>

Date: Mon, 19 Nov 2001 15:14:37

X-Message-Number: 15



I'm using Crystal Reports version 7 and have been successful at invoking a 

Crystal Reports report from ASP using IE, but am getting an error when 

running in Netscape: 



"Applet com.seagatesoftware.img.ReportViewer.ReportViewer class 

com.seagatesoftware.img.ReportViewer.ReportViewer could not be l..." 



(I'm guessing it says "loaded").  I'm using the Java Viewer code provided 

by Crystal Reports from an example on their site.  The code looks like 

this:



<SCRIPT LANGUAGE="JavaScript"><!--

var _ns3 = false;

var _ns4 = false;

//--></SCRIPT>

<SCRIPT LANGUAGE="JavaScript1.1"><!--

var _info = navigator.userAgent;

var _ns3 = (navigator.appName.indexOf("Netscape") >= 0 && _info.indexOf

("Mozilla/3") >= 0);

var _ns4 = (navigator.appName.indexOf("Netscape") >= 0 && _info.indexOf

("Mozilla/4") >= 0 );

//--></SCRIPT>



<SCRIPT LANGUAGE="JavaScript"><!--

if(_ns3==true)

document.writeln( '<applet 

code=com.seagatesoftware.img.ReportViewer.ReportViewer 

codebase="/viewer/JavaViewer" id=ReportViewer width=100% height=95% 

archive="/viewer/JavaViewer/ReportViewer.zip">' );

else if (_ns4 == true)

document.writeln( '<applet 

code=com.seagatesoftware.img.ReportViewer.ReportViewer 

codebase="/viewer/JavaViewer" id=ReportViewer width=100% height=95% 

archive="/viewer/JavaViewer/ReportViewer.jar">' );

else

document.writeln( '<applet 

code=com.seagatesoftware.img.ReportViewer.ReportViewer 

codebase="/viewer/JavaViewer" id=ReportViewer width=100% height=95%>' );

//--></SCRIPT>



<param name=Language value="en">

<param name=ReportName value="test.rpt">

<param name=ReportParameter value="">

<param name=HasGroupTree value="true">

<param name=ShowGroupTree value="true">

<param name=HasRefreshButton value="true">

<param name=HasPrintButton value="true">

<param name=HasExportButton value="true">

<param name=HasTextSearchControls value="true">

<param name=CanDrillDown value="true">

<param name=PromptOnRefresh value="true">

<param name=cabbase value="/viewer/JavaViewer/ReportViewer.cab">

</applet> 



Any idea why I'm getting the error?  Thanks in advance!!



----------------------------------------------------------------------



Subject: Re: Help with a query

From: "O'Hara, Elliott M" <EMOHARA@k...>

Date: Mon, 19 Nov 2001 10:10:14 -0500

X-Message-Number: 16



Its SQL 7.0



-----Original Message-----

From: Michiel van Otegem (lists ONLY) [mailto:michiel_lists@a...]

Sent: Monday, November 19, 2001 9:29 AM

To: ASP Web HowTo

Subject: [asp_web_howto] Re: Help with a query





In Access you can't do distributed queries, unless you have a link in DBx to

the tables in DBy. Transaction server won't help one bit, because it enlists

the Distributed Transaction Coordinator for database stuff... only one tiny

little problem... DTC can't talk properly to Access.



---

Michiel van Otegem

ASPNL.com    - ASP/ASP.NET/XML Teacher

ASPFriends.com - Moderator



http://www.aspnl.com

http://www.aspalliance.com/michiel

off-list email: michiel@a...

---

----- Original Message -----

From: "Serge Wagemakers" <swagemakers@d...>

To: "ASP Web HowTo" <asp_web_howto@p...>

Sent: Monday, November 19, 2001 1:54 PM

Subject: [asp_web_howto] Re: Help with a query





> Depends on the database server you're using to figure out the query.

> The way to go is to use a distributed query to get info from a table at

db1

> and

> insert it into a table in db2.

>

> In informix it's something like:

>

> SELECT O.order_num, C.fname, C.lname

>  FROM masterdb@c...:customer C, sales@b...:orders O

>  WHERE C.customer_num = O.Customer_num

>

> In Access I believe you have to have MS Transaction Server for using

> distributed

> queries.

>

> HTH,

>

> Serge

> ----- Original Message -----

> From: "O'Hara, Elliott M" <EMOHARA@k...>

> To: "ASP Web HowTo" <asp_web_howto@p...>

> Sent: Monday, November 19, 2001 12:59 PM

> Subject: [asp_web_howto] Help with a query

>

>

> > OK... I know there has to be a way to do this..

> > But its early and I can't think of it...

> >

> > I've got 2 separate Employee Databases and I only want one. I've altered

> the

> > tables on the one I want to keep to contain the columns that the db to

be

> > discarded has.

> >

> > now... I want to make a update query that first pulls the BEMSID column

> from

> > DB 1 (gunna die) and inserts it into the charBEMSID column in the DB 2

> (not

> > gunna die) WHERE the DB1.Lastname = DB2.Lastname and

> > DB1.FirstName=DB2.FirstName

> >

> > something like

> >

> > UPDATE tblEmployees

> > SET charBEMSID = (SELECT Server.Database.dbo.table.BEMSID FROM

> > Server.Database.dbo.table WHERE LastName = I AM LOST HERE)

> > WHERE LastName = LOST HERE TOO

> >

> > any ideas???

> >

> > Does that make any since?

> >

> > Thanks,

> > Elliott

> >




> $subst('Email.Unsub')

> >

>

>




$subst('Email.Unsub')

>

>







emohara@k...


$subst('Email.Unsub')



----------------------------------------------------------------------



Subject: Re: Help with a query

From:   "Serge Wagemakers" <swagemakers@d...>

Date:   Mon, 19 Nov 2001 16:35:22 +0100

X-Message-Number: 17



A helpful article would be:

http://www.sqlmag.com/Articles/Index.cfm?ArticleID=4829



Another very detailed and helpful article is:

http://www.elementkjournals.com/sql/0004/sql0041.htm



HTH,



Serge



----- Original Message -----

From: "O'Hara, Elliott M" <EMOHARA@k...>

To: "ASP Web HowTo" <asp_web_howto@p...>

Sent: Monday, November 19, 2001 4:10 PM

Subject: [asp_web_howto] Re: Help with a query





> Its SQL 7.0

>

> -----Original Message-----

> From: Michiel van Otegem (lists ONLY) [mailto:michiel_lists@a...]

> Sent: Monday, November 19, 2001 9:29 AM

> To: ASP Web HowTo

> Subject: [asp_web_howto] Re: Help with a query

>

>

> In Access you can't do distributed queries, unless you have a link in DBx

to

> the tables in DBy. Transaction server won't help one bit, because it

enlists

> the Distributed Transaction Coordinator for database stuff... only one

tiny

> little problem... DTC can't talk properly to Access.

>

> ---

> Michiel van Otegem

> ASPNL.com    - ASP/ASP.NET/XML Teacher

> ASPFriends.com - Moderator

>

> http://www.aspnl.com

> http://www.aspalliance.com/michiel

> off-list email: michiel@a...

> ---

> ----- Original Message -----

> From: "Serge Wagemakers" <swagemakers@d...>

> To: "ASP Web HowTo" <asp_web_howto@p...>

> Sent: Monday, November 19, 2001 1:54 PM

> Subject: [asp_web_howto] Re: Help with a query

>

>

> > Depends on the database server you're using to figure out the query.

> > The way to go is to use a distributed query to get info from a table at

> db1

> > and

> > insert it into a table in db2.

> >

> > In informix it's something like:

> >

> > SELECT O.order_num, C.fname, C.lname

> >  FROM masterdb@c...:customer C, sales@b...:orders O

> >  WHERE C.customer_num = O.Customer_num

> >

> > In Access I believe you have to have MS Transaction Server for using

> > distributed

> > queries.

> >

> > HTH,

> >

> > Serge

> > ----- Original Message -----

> > From: "O'Hara, Elliott M" <EMOHARA@k...>

> > To: "ASP Web HowTo" <asp_web_howto@p...>

> > Sent: Monday, November 19, 2001 12:59 PM

> > Subject: [asp_web_howto] Help with a query

> >

> >

> > > OK... I know there has to be a way to do this..

> > > But its early and I can't think of it...

> > >

> > > I've got 2 separate Employee Databases and I only want one. I've

altered

> > the

> > > tables on the one I want to keep to contain the columns that the db to

> be

> > > discarded has.

> > >

> > > now... I want to make a update query that first pulls the BEMSID

column

> > from

> > > DB 1 (gunna die) and inserts it into the charBEMSID column in the DB 2

> > (not

> > > gunna die) WHERE the DB1.Lastname = DB2.Lastname and

> > > DB1.FirstName=DB2.FirstName

> > >

> > > something like

> > >

> > > UPDATE tblEmployees

> > > SET charBEMSID = (SELECT Server.Database.dbo.table.BEMSID FROM

> > > Server.Database.dbo.table WHERE LastName = I AM LOST HERE)

> > > WHERE LastName = LOST HERE TOO

> > >

> > > any ideas???

> > >

> > > Does that make any since?

> > >

> > > Thanks,

> > > Elliott

> > >




> > $subst('Email.Unsub')

> > >

> >

> >



michiel_lists@a...


> $subst('Email.Unsub')

> >

> >

>

>



> emohara@k...


> $subst('Email.Unsub')

>




$subst('Email.Unsub')

>





----------------------------------------------------------------------



Subject: Problem with using JScript and VBScript in One File

From: anhdo@a...

Date: Mon, 19 Nov 2001 20:12:12

X-Message-Number: 18



How would I change the following JScript code below to work with VBScript 

on my ASP document.  Since my VBScript already has <%@languague 

="VBScript"%> how can I also use JScript too?  



I get the error: Active Server Pages, ASP 0141 (0x80004005)

The @ command can only be used once within the Active Server Page.



I want to modify the script below so that it no longer has the first line 

and I can embed it in one of my ASP documents?  How do I accomplish this?  

If you don't understand my question please email me at anhdo@a...  

Thank you!

----------------------------------------------------



<%@language = "JScript" %>



<%

   var feedId = 62;



   var refresher = new Date(  );

   var refresherMinutes = refresher.getMinutes(  );

   refresherMinutes = refresherMinutes - ( refresherMinutes % 5 );

   refresher.setMinutes( refresherMinutes, 0, 0 );



   var ctrl = Server.CreateObject( "SOFTWING.ASPtear" )

   var newzsnap = ctrl.retrieve

( "http://www.lobbynet.com/ppc_center_deliver/" +

                                 "deliver_articles.asp", 2,

                                 "searchId=" + String( feedId ) + "&" +

                                 "forceReload=" + refresher.getTime(  ),

                                 "", "" );

   var ctrl = null;

 %>



<%= newzsnap %>



----------------------------------------------------------------------



Subject: RE: Problem with using JScript and VBScript in On-     e File

From: Kyle Burns <kburns@c...>

Date: Mon, 19 Nov 2001 15:08:12 -0500

X-Message-Number: 19



You need to use the RUNAT attribute of your script element...

<SCRIPT LANGUAGE="JScript" RUNAT="Server">







=================================

Kyle M. Burns, MCSD, MCT

ECommerce Technology Manager

Centra Credit Union

kburns@c...



 



-----Original Message-----

From: anhdo@a... [mailto:anhdo@a...]

Sent: Monday, November 19, 2001 3:12 PM

To: ASP Web HowTo

Subject: [asp_web_howto] Problem with using JScript and VBScript in One

File





How would I change the following JScript code below to work with VBScript 

on my ASP document.  Since my VBScript already has <%@languague 

="VBScript"%> how can I also use JScript too?  



I get the error: Active Server Pages, ASP 0141 (0x80004005)

The @ command can only be used once within the Active Server Page.



I want to modify the script below so that it no longer has the first line 

and I can embed it in one of my ASP documents?  How do I accomplish this?  

If you don't understand my question please email me at anhdo@a...  

Thank you!

----------------------------------------------------



<%@language = "JScript" %>



<%

   var feedId = 62;



   var refresher = new Date(  );

   var refresherMinutes = refresher.getMinutes(  );

   refresherMinutes = refresherMinutes - ( refresherMinutes % 5 );

   refresher.setMinutes( refresherMinutes, 0, 0 );



   var ctrl = Server.CreateObject( "SOFTWING.ASPtear" )

   var newzsnap = ctrl.retrieve

( "http://www.lobbynet.com/ppc_center_deliver/" +

                                 "deliver_articles.asp", 2,

                                 "searchId=" + String( feedId ) + "&" +

                                 "forceReload=" + refresher.getTime(  ),

                                 "", "" );

   var ctrl = null;

 %>



<%= newzsnap %>






$subst('Email.Unsub')



----------------------------------------------------------------------



Subject: RE: Problem with using JScript and VBScript i-     n On e File

From: "Do, Anh" <Anhdo@a...>

Date: Mon, 19 Nov 2001 15:16:52 -0500

X-Message-Number: 20



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_01C17137.208F5990

Content-Type: text/plain



I tried using <SCRIPT LANGUAGE="JScript" RUNAT="Server"> but then <% in the

code come up as a syntax error.

This is what I tried below:



----------------------------------

<SCRIPT LANGUAGE="JScript" RUNAT="Server">

	<%

	   var feedId = 62;



	   var refresher = new Date(  );

	   var refresherMinutes = refresher.getMinutes(  );

	   refresherMinutes = refresherMinutes - ( refresherMinutes % 5 );

	   refresher.setMinutes( refresherMinutes, 0, 0 );



	   var ctrl = Server.CreateObject( "SOFTWING.ASPtear" )

	   var newzsnap = ctrl.retrieve

	( "http://www.lobbynet.com/ppc_center_deliver/" +

	                                 "deliver_articles.asp", 2,

	                                 "searchId=" + String( feedId ) +

"&" +

	                                 "forceReload=" + refresher.getTime(

),

	                                 "", "" );

	   var ctrl = null;

	 %>



	<%= newzsnap %>

	</SCRIPT>

---------------------





> -----Original Message-----

> From:	Kyle Burns [SMTP:kburns@c...]

> Sent:	Monday, November 19, 2001 3:08 PM

> To:	ASP Web HowTo

> Subject:	[asp_web_howto] RE: Problem with using JScript and VBScript

in On e File

> 

> You need to use the RUNAT attribute of your script element...

> <SCRIPT LANGUAGE="JScript" RUNAT="Server">

> 

> 

> 

> =================================

> Kyle M. Burns, MCSD, MCT

> ECommerce Technology Manager

> Centra Credit Union

> kburns@c...

> 

>  

> 

> -----Original Message-----

> From: anhdo@a... [mailto:anhdo@a...]

> Sent: Monday, November 19, 2001 3:12 PM

> To: ASP Web HowTo

> Subject: [asp_web_howto] Problem with using JScript and VBScript in One

> File

> 

> 

> How would I change the following JScript code below to work with VBScript 

> on my ASP document.  Since my VBScript already has <%@languague 

> ="VBScript"%> how can I also use JScript too?  

> 

> I get the error: Active Server Pages, ASP 0141 (0x80004005)

> The @ command can only be used once within the Active Server Page.

> 

> I want to modify the script below so that it no longer has the first line 

> and I can embed it in one of my ASP documents?  How do I accomplish this?



> If you don't understand my question please email me at anhdo@a...  

> Thank you!

> ----------------------------------------------------

> 

> <%@language = "JScript" %>

> 

> <%

>    var feedId = 62;

> 

>    var refresher = new Date(  );

>    var refresherMinutes = refresher.getMinutes(  );

>    refresherMinutes = refresherMinutes - ( refresherMinutes % 5 );

>    refresher.setMinutes( refresherMinutes, 0, 0 );

> 

>    var ctrl = Server.CreateObject( "SOFTWING.ASPtear" )

>    var newzsnap = ctrl.retrieve

> ( "http://www.lobbynet.com/ppc_center_deliver/" +

>                                  "deliver_articles.asp", 2,

>                                  "searchId=" + String( feedId ) + "&" +

>                                  "forceReload=" + refresher.getTime(  ),

>                                  "", "" );

>    var ctrl = null;

>  %>

> 

> <%= newzsnap %>

> 




> $subst('Email.Unsub')

> 




$subst('Email.Unsub')






----------------------------------------------------------------------



Subject: RE: Problem with using JScript and VBScript i-      n On e File

From: Kyle Burns <kburns@c...>

Date: Mon, 19 Nov 2001 15:19:24 -0500

X-Message-Number: 21



The <SCRIPT> and </SCRIPT> tags are your script delimeters in this scenario.

Omit <% and %>.  Why would you want to mix your script anyway?  This really

cuts the maintainability of your page and adds to processing time because

another script engine needs to be loaded.





=================================

Kyle M. Burns, MCSD, MCT

ECommerce Technology Manager

Centra Credit Union

kburns@c...



 



-----Original Message-----

From: Do, Anh [mailto:Anhdo@a...]

Sent: Monday, November 19, 2001 3:17 PM

To: ASP Web HowTo

Subject: [asp_web_howto] RE: Problem with using JScript and VBScript i n On

e File





I tried using <SCRIPT LANGUAGE="JScript" RUNAT="Server"> but then <% in the

code come up as a syntax error. 

This is what I tried below: 

---------------------------------- 

<SCRIPT LANGUAGE="JScript" RUNAT="Server"> 

<% 

   var feedId = 62; 

   var refresher = new Date(  ); 

   var refresherMinutes = refresher.getMinutes(  ); 

   refresherMinutes = refresherMinutes - ( refresherMinutes % 5 ); 

   refresher.setMinutes( refresherMinutes, 0, 0 ); 

   var ctrl = Server.CreateObject( "SOFTWING.ASPtear" ) 

   var newzsnap = ctrl.retrieve 

( "http://www.lobbynet.com/ppc_center_deliver/" + 

                                 "deliver_articles.asp", 2, 

                                 "searchId=" + String( feedId ) + "&" + 

                                 "forceReload=" + refresher.getTime(  ), 

                                 "", "" ); 

   var ctrl = null; 

 %> 

<%= newzsnap %> 

</SCRIPT> 

--------------------- 





-----Original Message----- 

From:   Kyle Burns [SMTP:kburns@c...] 

Sent:   Monday, November 19, 2001 3:08 PM 

To:     ASP Web HowTo 

Subject:        [asp_web_howto] RE: Problem with using JScript and VBScript

in On e File 

You need to use the RUNAT attribute of your script element... 

<SCRIPT LANGUAGE="JScript" RUNAT="Server"> 







================================= 

Kyle M. Burns, MCSD, MCT 

ECommerce Technology Manager 

Centra Credit Union 

kburns@c... 

 

-----Original Message----- 

From: anhdo@a... [mailto:anhdo@a...] 

Sent: Monday, November 19, 2001 3:12 PM 

To: ASP Web HowTo 

Subject: [asp_web_howto] Problem with using JScript and VBScript in One 

File 





How would I change the following JScript code below to work with VBScript 

on my ASP document.  Since my VBScript already has <%@languague 

="VBScript"%> how can I also use JScript too?  

I get the error: Active Server Pages, ASP 0141 (0x80004005) 

The @ command can only be used once within the Active Server Page. 

I want to modify the script below so that it no longer has the first line 

and I can embed it in one of my ASP documents?  How do I accomplish this?  

If you don't understand my question please email me at anhdo@a...  

Thank you! 

---------------------------------------------------- 

<%@language = "JScript" %> 

<% 

   var feedId = 62; 

   var refresher = new Date(  ); 

   var refresherMinutes = refresher.getMinutes(  ); 

   refresherMinutes = refresherMinutes - ( refresherMinutes % 5 ); 

   refresher.setMinutes( refresherMinutes, 0, 0 ); 

   var ctrl = Server.CreateObject( "SOFTWING.ASPtear" ) 

   var newzsnap = ctrl.retrieve 

( "http://www.lobbynet.com/ppc_center_deliver/" + 

                                 "deliver_articles.asp", 2, 

                                 "searchId=" + String( feedId ) + "&" + 

                                 "forceReload=" + refresher.getTime(  ), 

                                 "", "" ); 

   var ctrl = null; 

 %> 

<%= newzsnap %> 

--- 



$subst('Email.Unsub') 

--- 



$subst('Email.Unsub') 




$subst('Email.Unsub')



----------------------------------------------------------------------



Subject: RE: Problem with using JScript and VBScript in On-     e File

From: "Johnson, Israel" <IJohnson@R...>

Date: Mon, 19 Nov 2001 15:35:41 -0500

X-Message-Number: 22



<Script Language="JScript" RunAt ="Server">

	//script goes here



</Script>



-----Original Message-----

From: anhdo@a... [mailto:anhdo@a...]

Sent: Monday, November 19, 2001 3:12 PM

To: ASP Web HowTo

Subject: [asp_web_howto] Problem with using JScript and VBScript in One

File





How would I change the following JScript code below to work with VBScript 

on my ASP document.  Since my VBScript already has <%@languague 

="VBScript"%> how can I also use JScript too?  



I get the error: Active Server Pages, ASP 0141 (0x80004005)

The @ command can only be used once within the Active Server Page.



I want to modify the script below so that it no longer has the first line 

and I can embed it in one of my ASP documents?  How do I accomplish this?  

If you don't understand my question please email me at anhdo@a...  

Thank you!

----------------------------------------------------



<%@language = "JScript" %>



<%

   var feedId = 62;



   var refresher = new Date(  );

   var refresherMinutes = refresher.getMinutes(  );

   refresherMinutes = refresherMinutes - ( refresherMinutes % 5 );

   refresher.setMinutes( refresherMinutes, 0, 0 );



   var ctrl = Server.CreateObject( "SOFTWING.ASPtear" )

   var newzsnap = ctrl.retrieve

( "http://www.lobbynet.com/ppc_center_deliver/" +

                                 "deliver_articles.asp", 2,

                                 "searchId=" + String( feedId ) + "&" +

                                 "forceReload=" + refresher.getTime(  ),

                                 "", "" );

   var ctrl = null;

 %>



<%= newzsnap %>






$subst('Email.Unsub')



----------------------------------------------------------------------



Subject: RE: Problem with using JScript and VBScript i-      n On e File

From: "Do, Anh" <Anhdo@a...>

Date: Mon, 19 Nov 2001 15:36:04 -0500

X-Message-Number: 23



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_01C17139.CEEF5330

Content-Type: text/plain;

	charset="iso-8859-1"



Thanks!  I solved the problem.  The reason we are using two different types

of script is that we are embedding a special client that we did not create.

Since we originally created our page in VBscript we had to modify it to add

this JScript code.



The code worked for me when I did this:

---------------------------------------------------------------------

<SCRIPT LANGUAGE="JScript" RUNAT="Server">





   var feedId = 62;



   var refresher = new Date(  );

   var refresherMinutes = refresher.getMinutes(  );

   refresherMinutes = refresherMinutes - ( refresherMinutes % 5 );

   refresher.setMinutes( refresherMinutes, 0, 0 );



   var ctrl = Server.CreateObject( "SOFTWING.ASPtear" )

   var newzsnap = ctrl.retrieve(

"http://www.lobbynet.com/ppc_center_deliver/" +

                                 "deliver_articles.asp", 2,

                                 "searchId=" + String( feedId ) + "&" +

                                 "forceReload=" + refresher.getTime(  ),

                                 "", "" );

   var ctrl = null;

</SCRIPT>

<%= newzsnap %>







> -----Original Message-----

> From:	Kyle Burns [SMTP:kburns@c...]

> Sent:	Monday, November 19, 2001 3:19 PM

> To:	ASP Web HowTo

> Subject:	[asp_web_howto] RE: Problem with using JScript and VBScript

i n On e File

> 

> The <SCRIPT> and </SCRIPT> tags are your script delimeters in this

scenario.

> Omit <% and %>.  Why would you want to mix your script anyway?  This

really

> cuts the maintainability of your page and adds to processing time because

> another script engine needs to be loaded.

> 

> 

> =================================

> Kyle M. Burns, MCSD, MCT

> ECommerce Technology Manager

> Centra Credit Union

> kburns@c...

> 

>  

> 

> -----Original Message-----

> From: Do, Anh [mailto:Anhdo@a...]

> Sent: Monday, November 19, 2001 3:17 PM

> To: ASP Web HowTo

> Subject: [asp_web_howto] RE: Problem with using JScript and VBScript i n

On

> e File

> 

> 

> I tried using <SCRIPT LANGUAGE="JScript" RUNAT="Server"> but then <% in

the

> code come up as a syntax error. 

> This is what I tried below: 

> ---------------------------------- 

> <SCRIPT LANGUAGE="JScript" RUNAT="Server"> 

> <% 

>    var feedId = 62; 

>    var refresher = new Date(  ); 

>    var refresherMinutes = refresher.getMinutes(  ); 

>    refresherMinutes = refresherMinutes - ( refresherMinutes % 5 ); 

>    refresher.setMinutes( refresherMinutes, 0, 0 ); 

>    var ctrl = Server.CreateObject( "SOFTWING.ASPtear" ) 

>    var newzsnap = ctrl.retrieve 

> ( "http://www.lobbynet.com/ppc_center_deliver/" + 

>                                  "deliver_articles.asp", 2, 

>                                  "searchId=" + String( feedId ) + "&" + 

>                                  "forceReload=" + refresher.getTime(  ), 

>                                  "", "" ); 

>    var ctrl = null; 

>  %> 

> <%= newzsnap %> 

> </SCRIPT> 

> --------------------- 

> 

> 

> -----Original Message----- 

> From:   Kyle Burns [SMTP:kburns@c...] 

> Sent:   Monday, November 19, 2001 3:08 PM 

> To:     ASP Web HowTo 

> Subject:        [asp_web_howto] RE: Problem with using JScript and

VBScript

> in On e File 

> You need to use the RUNAT attribute of your script element... 

> <SCRIPT LANGUAGE="JScript" RUNAT="Server"> 

> 

> 

> 

> ================================= 

> Kyle M. Burns, MCSD, MCT 

> ECommerce Technology Manager 

> Centra Credit Union 

> kburns@c... 

>  

> -----Original Message----- 

> From: anhdo@a... [mailto:anhdo@a...] 

> Sent: Monday, November 19, 2001 3:12 PM 

> To: ASP Web HowTo 

> Subject: [asp_web_howto] Problem with using JScript and VBScript in One 

> File 

> 

> 

> How would I change the following JScript code below to work with VBScript 

> on my ASP document.  Since my VBScript already has <%@languague 

> ="VBScript"%> how can I also use JScript too?  

> I get the error: Active Server Pages, ASP 0141 (0x80004005) > 

> The @ command can only be used once within the Active Server Page. 

> I want to modify the script below so that it no longer has the first line 

> and I can embed it in one of my ASP documents?  How do I accomplish this?



> If you don't understand my question please email me at anhdo@a...  

> Thank you! 

> ---------------------------------------------------- 

> <%@language = "JScript" %> 

> <% 

>    var feedId = 62; 

>    var refresher = new Date(  ); 

>    var refresherMinutes = refresher.getMinutes(  ); 

>    refresherMinutes = refresherMinutes - ( refresherMinutes % 5 ); 

>    refresher.setMinutes( refresherMinutes, 0, 0 ); 

>    var ctrl = Server.CreateObject( "SOFTWING.ASPtear" ) 

>    var newzsnap = ctrl.retrieve 

> ( "http://www.lobbynet.com/ppc_center_deliver/" + 

>                                  "deliver_articles.asp", 2, 

>                                  "searchId=" + String( feedId ) + "&" + 

>                                  "forceReload=" + refresher.getTime(  ), 

>                                  "", "" ); 

>    var ctrl = null; 

>  %> 

> <%= newzsnap %> 

> --- 



> $subst('Email.Unsub') 

> --- 



> $subst('Email.Unsub') 




> $subst('Email.Unsub')

> 




$subst('Email.Unsub')






----------------------------------------------------------------------



Subject: RE: Problem with using JScript and VBScript i-      n On e File

From: Kyle Burns <kburns@c...>

Date: Mon, 19 Nov 2001 15:39:48 -0500

X-Message-Number: 24



It seems like this should also work in VBScript with minimal re-working.  Is

there a reason this won't work?



=================================

Kyle M. Burns, MCSD, MCT

ECommerce Technology Manager

Centra Credit Union

kburns@c...



 



-----Original Message-----

From: Do, Anh [mailto:Anhdo@a...]

Sent: Monday, November 19, 2001 3:36 PM

To: ASP Web HowTo

Subject: [asp_web_howto] RE: Problem with using JScript and VBScript i n On

e File





Thanks!  I solved the problem.  The reason we are using two different types

of script is that we are embedding a special client that we did not create.

Since we originally created our page in VBscript we had to modify it to add

this JScript code.

The code worked for me when I did this: 

--------------------------------------------------------------------- 

<SCRIPT LANGUAGE="JScript" RUNAT="Server"> 





   var feedId = 62; 

   var refresher = new Date(  ); 

   var refresherMinutes = refresher.getMinutes(  ); 

   refresherMinutes = refresherMinutes - ( refresherMinutes % 5 ); 

   refresher.setMinutes( refresherMinutes, 0, 0 ); 

   var ctrl = Server.CreateObject( "SOFTWING.ASPtear" ) 

   var newzsnap = ctrl.retrieve(

"http://www.lobbynet.com/ppc_center_deliver/" + 

                                 "deliver_articles.asp", 2, 

                                 "searchId=" + String( feedId ) + "&" + 

                                 "forceReload=" + refresher.getTime(  ), 

                                 "", "" ); 

   var ctrl = null; 

</SCRIPT> 

<%= newzsnap %> 







-----Original Message----- 

From:   Kyle Burns [SMTP:kburns@c...] 

Sent:   Monday, November 19, 2001 3:19 PM 

To:     ASP Web HowTo 

Subject:        [asp_web_howto] RE: Problem with using JScript and VBScript

i n On e File 

The <SCRIPT> and </SCRIPT> tags are your script delimeters in this scenario.



Omit <% and %>.  Why would you want to mix your script anyway?  This really 

cuts the maintainability of your page and adds to processing time because 

another script engine needs to be loaded. 





================================= 

Kyle M. Burns, MCSD, MCT 

ECommerce Technology Manager 

Centra Credit Union 

kburns@c... 

 

-----Original Message----- 

From: Do, Anh [mailto:Anhdo@a...] 

Sent: Monday, November 19, 2001 3:17 PM 

To: ASP Web HowTo 

Subject: [asp_web_howto] RE: Problem with using JScript and VBScript i n On 

e File 





I tried using <SCRIPT LANGUAGE="JScript" RUNAT="Server"> but then <% in the 

code come up as a syntax error. 

This is what I tried below: 

---------------------------------- 

<SCRIPT LANGUAGE="JScript" RUNAT="Server"> 

<% 

   var feedId = 62; 

   var refresher = new Date(  ); 

   var refresherMinutes = refresher.getMinutes(  ); 

   refresherMinutes = refresherMinutes - ( refresherMinutes % 5 ); 

   refresher.setMinutes( refresherMinutes, 0, 0 ); 

   var ctrl = Server.CreateObject( "SOFTWING.ASPtear" ) 

   var newzsnap = ctrl.retrieve 

( "http://www.lobbynet.com/ppc_center_deliver/" + 

                                 "deliver_articles.asp", 2, 

                                 "searchId=" + String( feedId ) + "&" + 

                                 "forceReload=" + refresher.getTime(  ), 

                                 "", "" ); 

   var ctrl = null; 

 %> 

<%= newzsnap %> 

</SCRIPT> 

--------------------- 





-----Original Message----- 

From:   Kyle Burns [SMTP:kburns@c...] 

Sent:   Monday, November 19, 2001 3:08 PM 

To:     ASP Web HowTo 

Subject:        [asp_web_howto] RE: Problem with using JScript and VBScript 

in On e File 

You need to use the RUNAT attribute of your script element... 

<SCRIPT LANGUAGE="JScript" RUNAT="Server"> 







================================= 

Kyle M. Burns, MCSD, MCT 

ECommerce Technology Manager 

Centra Credit Union 

kburns@c... 

  

-----Original Message----- 

From: anhdo@a... [mailto:anhdo@a...] 

Sent: Monday, November 19, 2001 3:12 PM 

To: ASP Web HowTo 

Subject: [asp_web_howto] Problem with using JScript and VBScript in One 

File 





How would I change the following JScript code below to work with VBScript 

on my ASP document.  Since my VBScript already has <%@languague 

="VBScript"%> how can I also use JScript too?  

I get the error: Active Server Pages, ASP 0141 (0x80004005) 

The @ command can only be used once within the Active Server Page. 

I want to modify the script below so that it no longer has the first line 

and I can embed it in one of my ASP documents?  How do I accomplish this?  

If you don't understand my question please email me at anhdo@a...  

Thank you! 

---------------------------------------------------- 

<%@language = "JScript" %> 

<% 

   var feedId = 62; 

   var refresher = new Date(  ); 

   var refresherMinutes = refresher.getMinutes(  ); 

   refresherMinutes = refresherMinutes - ( refresherMinutes % 5 ); 

   refresher.setMinutes( refresherMinutes, 0, 0 ); 

   var ctrl = Server.CreateObject( "SOFTWING.ASPtear" ) 

   var newzsnap = ctrl.retrieve 

( "http://www.lobbynet.com/ppc_center_deliver/" + 

                                 "deliver_articles.asp", 2, 

                                 "searchId=" + String( feedId ) + "&" + 

                                 "forceReload=" + refresher.getTime(  ), 

                                 "", "" ); 

   var ctrl = null; 

 %> 

<%= newzsnap %> 

--- 



$subst('Email.Unsub') 

--- 



$subst('Email.Unsub') 

--- 



$subst('Email.Unsub') 

--- 



$subst('Email.Unsub') 




$subst('Email.Unsub')



----------------------------------------------------------------------



Subject: RE: Problem with using JScript and VBScript i-      n On e File

From: "Do, Anh" <Anhdo@a...>

Date: Mon, 19 Nov 2001 15:49:59 -0500

X-Message-Number: 25



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_01C1713B.C08538D0

Content-Type: text/plain



I tried using VBScript with it but when I did I got an error at the line of

code:  var feedId = 62; 

I'm not sure why myself, but I assume because the code was written

specifically in JScript I need to have a script tag for the JScript..





> -----Original Message-----

> From:	Kyle Burns [SMTP:kburns@c...]

> Sent:	Monday, November 19, 2001 3:40 PM

> To:	ASP Web HowTo

> Subject:	[asp_web_howto] RE: Problem with using JScript and VBScript

i n On e File

> 

> It seems like this should also work in VBScript with minimal re-working.

Is

> there a reason this won't work?

> 

> =================================

> Kyle M. Burns, MCSD, MCT

> ECommerce Technology Manager

> Centra Credit Union

> kburns@c...

> 

>  

> 

> -----Original Message-----

> From: Do, Anh [mailto:Anhdo@a...]

> Sent: Monday, November 19, 2001 3:36 PM

> To: ASP Web HowTo

> Subject: [asp_web_howto] RE: Problem with using JScript and VBScript i n

On

> e File

> 

> 

> Thanks!  I solved the problem.  The reason we are using two different

types

> of script is that we are embedding a special client that we did not

create.

> Since we originally created our page in VBscript we had to modify it to

add

> this JScript code.

> The code worked for me when I did this: 

> --------------------------------------------------------------------- 

> <SCRIPT LANGUAGE="JScript" RUNAT="Server"> 

> 

> 

>    var feedId = 62; 

>    var refresher = new Date(  ); 

>    var refresherMinutes = refresher.getMinutes(  ); 

>    refresherMinutes = refresherMinutes - ( refresherMinutes % 5 ); 

>    refresher.setMinutes( refresherMinutes, 0, 0 ); 

>    var ctrl = Server.CreateObject( "SOFTWING.ASPtear" ) 

>    var newzsnap = ctrl.retrieve(

> "http://www.lobbynet.com/ppc_center_deliver/" + 

>                                  "deliver_articles.asp", 2, 

>                                  "searchId=" + String( feedId ) + "&" + 

>                                  "forceReload=" + refresher.getTime(  ), 

>                                  "", "" ); 

>    var ctrl = null; 

> </SCRIPT> 

> <%= newzsnap %> 

> 

> 

> 

> 






----------------------------------------------------------------------



Subject: Re: new window

From: riley@i...

Date: Mon, 19 Nov 2001 21:23:50

X-Message-Number: 26



I see a few Javascript answers, which is what I found when I first started 

looking for this kind of solution.  You don't need to use Javascript, you 

can do it with vbscript.  I say this since it sounded like you wanted a 

vbscript-asp answer.  



here's some client side script:



sub myPopup()



dim myWindow



with document.frmMyForm



myWindow=window.open("popupWindow.asp","_blank","height=100,width=100")



end with



end sub



Now, I usually call this sub on a button click event or an HREF (anchor, 

link) click event, but you can call it on a mouseover, text box change, 

whenever.



You can also use ASP to generate this client-side script dynamically, 

which can come in really handy.  Lemme know if this works for ya, and good 

luck.















> 

> This is a multi-part message in MIME format.

> 

> ------=_NextPart_000_002D_01C1696B.F5A25C00

> Content-Type: text/plain;

> 	charset="iso-8859-1"

> Content-Transfer-Encoding: quoted-printable

> 

> You should some client side scripting there like javascript.  You can a 

> find a lot of the scripts you want at www.javascripts.com

> 

> Enzo

>   ----- Original Message -----

>   From: Rob v. Osnabrugge

>   To: ASP Web HowTo

>   Sent: Thursday, November 08, 2001 10:24 PM

>   Subject: [asp_web_howto] new window

> 

> 

>   Hello,

>   I'm looking for an (ASP) function, from which I can open another new 

> ASP

>   webpage, but with a given size and with parameters. Something like

>   href=3Dxxx.asp?yy=3Da&zz=3Dc width=3D300 height=3D400

> 

>   Thanks,

>   Rob

> 




> $subst('Email.Unsub')

> 

> 

> ------=_NextPart_000_002D_01C1696B.F5A25C00

> Content-Type: text/html;

> 	charset="iso-8859-1"

> Content-Transfer-Encoding: quoted-printable

> 

> <!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.4522.1800" name=3DGENERATOR>

> <STYLE></STYLE>

> </HEAD>

> <BODY bgColor=3D#ffffff>

> <DIV><FONT face=3DVerdana size=3D2>You should some client side scripting 



> there like

> javascript.&nbsp; You can a find a lot of the scripts you want at <A

> href=3D"http://www.javascripts.com">www.javascripts.com</A></FONT></DIV>

> <DIV><FONT face=3DVerdana size=3D2></FONT>&nbsp;</DIV>

> <DIV><FONT face=3DVerdana size=3D2>Enzo</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=3Dosnabrr@h... href=3D"mailto:osnabrr@h...">Rob 



> v.

>   Osnabrugge</A> </DIV>

>   <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A 

> title=3Dasp_web_howto@p...

>   href=3D"mailto:asp_web_howto@p...">ASP Web HowTo</A> </DIV>

>   <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Thursday, November 08, 

> 2001 10:24

>   PM</DIV>

>   <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> [asp_web_howto] new 

> window</DIV>

>   <DIV><BR></DIV>Hello,<BR>I'm looking for an (ASP) function, from which 



> I can

>   open another new ASP <BR>webpage, but with a given size and with 

> parameters.

>   Something like <BR>href=3Dxxx.asp?yy=3Da&amp;zz=3Dc width=3D300

>   height=3D400<BR><BR>Thanks,<BR>Rob<BR><BR>---<BR>You are currently 

> subscribed to

>   asp_web_howto as: <A 

> href=3D"mailto:enzaux@g...">enzaux@g...</A><BR>To

>   unsubscribe send a blank email to <A

>   

> href=3D"mailto:$subst('Email.Unsub')">leave-asp_web_ho

> wto-659864M@p...</A><BR></BLOCKQUOTE></BODY></HTML>

> 

> ------=_NextPart_000_002D_01C1696B.F5A25C00--

> 



----------------------------------------------------------------------



Subject: Re: new window

From: Kyle Burns <kburns@c...>

Date: Mon, 19 Nov 2001 16:18:25 -0500

X-Message-Number: 27



Opening new windows is a client operation.  Can't be done on the server

(ASP).





=================================

Kyle M. Burns, MCSD, MCT

ECommerce Technology Manager

Centra Credit Union

kburns@c...



 



-----Original Message-----

From: riley@i... [mailto:riley@i...]

Sent: Monday, November 19, 2001 4:24 PM

To: ASP Web HowTo

Subject: [asp_web_howto] Re: new window





I see a few Javascript answers, which is what I found when I first started 

looking for this kind of solution.  You don't need to use Javascript, you 

can do it with vbscript.  I say this since it sounded like you wanted a 

vbscript-asp answer.  



here's some client side script:



sub myPopup()



dim myWindow



with document.frmMyForm



myWindow=window.open("popupWindow.asp","_blank","height=100,width=100")



end with



end sub



Now, I usually call this sub on a button click event or an HREF (anchor, 

link) click event, but you can call it on a mouseover, text box change, 

whenever.



You can also use ASP to generate this client-side script dynamically, 

which can come in really handy.  Lemme know if this works for ya, and good 

luck.















> 

> This is a multi-part message in MIME format.

> 

> ------=_NextPart_000_002D_01C1696B.F5A25C00

> Content-Type: text/plain;

> 	charset="iso-8859-1"

> Content-Transfer-Encoding: quoted-printable

> 

> You should some client side scripting there like javascript.  You can a 

> find a lot of the scripts you want at www.javascripts.com

> 

> Enzo

>   ----- Original Message -----

>   From: Rob v. Osnabrugge

>   To: ASP Web HowTo

>   Sent: Thursday, November 08, 2001 10:24 PM

>   Subject: [asp_web_howto] new window

> 

> 

>   Hello,

>   I'm looking for an (ASP) function, from which I can open another new 

> ASP

>   webpage, but with a given size and with parameters. Something like

>   href=3Dxxx.asp?yy=3Da&zz=3Dc width=3D300 height=3D400

> 

>   Thanks,

>   Rob

> 




> $subst('Email.Unsub')

> 

> 

> ------=_NextPart_000_002D_01C1696B.F5A25C00

> Content-Type: text/html;

> 	charset="iso-8859-1"

> Content-Transfer-Encoding: quoted-printable

> 

> <!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.4522.1800" name=3DGENERATOR>

> <STYLE></STYLE>

> </HEAD>

> <BODY bgColor=3D#ffffff>

> <DIV><FONT face=3DVerdana size=3D2>You should some client side scripting 



> there like

> javascript.&nbsp; You can a find a lot of the scripts you want at <A

> href=3D"http://www.javascripts.com">www.javascripts.com</A></FONT></DIV>

> <DIV><FONT face=3DVerdana size=3D2></FONT>&nbsp;</DIV>

> <DIV><FONT face=3DVerdana size=3D2>Enzo</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=3Dosnabrr@h... href=3D"mailto:osnabrr@h...">Rob 



> v.

>   Osnabrugge</A> </DIV>

>   <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A 

> title=3Dasp_web_howto@p...

>   href=3D"mailto:asp_web_howto@p...">ASP Web HowTo</A> </DIV>

>   <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Thursday, November 08, 

> 2001 10:24

>   PM</DIV>

>   <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> [asp_web_howto] new 

> window</DIV>

>   <DIV><BR></DIV>Hello,<BR>I'm looking for an (ASP) function, from which 



> I can

>   open another new ASP <BR>webpage, but with a given size and with 

> parameters.

>   Something like <BR>href=3Dxxx.asp?yy=3Da&amp;zz=3Dc width=3D300

>   height=3D400<BR><BR>Thanks,<BR>Rob<BR><BR>---<BR>You are currently 

> subscribed to

>   asp_web_howto as: <A 

> href=3D"mailto:enzaux@g...">enzaux@g...</A><BR>To

>   unsubscribe send a blank email to <A

>   

> href=3D"mailto:$subst('Email.Unsub')">leave-asp_web_ho

> wto-659864M@p...</A><BR></BLOCKQUOTE>

---<BR>

You are currently subscribed to asp_web_howto as: kburns@c...<BR>


$subst('Email.Unsub')<BR>



</BODY></HTML>

> 

> ------=_NextPart_000_002D_01C1696B.F5A25C00--

> 



----------------------------------------------------------------------



Subject: Re: Generating doc files from ASP

From: riley@i...

Date: Mon, 19 Nov 2001 21:33:52

X-Message-Number: 28



There are all kinds of tutorials out there that explain how to create and 

write to a text file on the server.  I experimented using the .doc 

extension, instead of the .txt extension, and it worked great.  The cool 

thing is, you can create this file on the fly, and then direct your users 

browser to that file, and you get a Word container within the browser.  

You can do the same thing with excel files, but it's a little trickier.  

Excel can recognize html tables as tables, but you have to make sure that 

you have all the proper tags to make the column headings work correctly.  

I have seen several tutorials out there that talk about changing the 

contentType of the response object, but I'll be darned if I can make that 

work.. yet.



Best of luck.





> Hi coders,

>               I am generating some content thru my ASP program, for 

> example a Report containg tabular data, however I would like this to be 

> created as a doc file.

> I tried this by changing the ContentType of the RESPONSE object, 

> however, I ended up with a doc file containing the HTML code of the 

> resultant page. What I really wanted was for this page to contain the 

> end-data not the code.

> 

> Can anyone help me on this.

> 

> Also I'd like some information on generating Excel & PDF files thru ASP.

> 

> Thanks in advance.

> Dennis.



----------------------------------------------------------------------



Subject: Re: Links

From: "John Tarbell" <kmind711@a...>

Date: Mon, 19 Nov 2001 22:22:15

X-Message-Number: 29



> Hi John,

> 

> When people do things like "filename.asp?id=23" they are typically

> connecting to a database and displaying the results of a specific record 

in

> the DB which is called when a user does something, like clicking on a

> hyperlink.  The number is usually the unique key identifier for the 

record.

> 

> In the code, this is assigned dynamically by writing the SQL statement

> on-the-fly.  An example of this would be:

> 

> Dim id, strSQL

> strSQL = "SELECT * FROM tableName WHERE id = '" & id & "'"

> 

> ...this would call upon a precice value for the "id" (again, typically 

the

> unique key in a DB table) and then bring up that record.

> 

> HTH,

> Jason

> 

OK, thanks again for all your help and, yes, I do have another question! 

(sorry) I know that you are supposed to use Access databases but I donnot 

have that and was wondering if I could use a Microsoft Works database? If 

so, would I do anything different with a Works database and an Access 

database?



Thanks,

John 



> 

> 

> 

> ----- Original Message -----

> From: "John Tarbell" <kmind711@a...>

> To: "ASP Web HowTo" <asp_web_howto@p...>

> Sent: Sunday, November 18, 2001 11:47 PM

> Subject: [asp_web_howto] Re: Links

> 

> 

> >> OK, i understand how to do the code with like the first name and last

> name

> > but i see on the links how it says like ?id=23 or whatever and when i 

go

> > to the page it has a lot of things on the page but it never says like 

that

> > the id=23 on the page. How is this done?

> 

> 



----------------------------------------------------------------------



Subject: Re: Links

From: "Jason Salas" <jason@k...>

Date: Tue, 20 Nov 2001 08:28:40 +1000

X-Message-Number: 30



Hmmm...ouch.  I don't believe there's a way to connect an MS Works database

to a Web pages...Works' DB program isn't really a "real" DB application,

like Access or SQL Server would be.  Like the rest of the tools in Works,

it's a scaled-down version of a traditional business app.



Jason





----- Original Message -----

From: "John Tarbell" <kmind711@a...>

To: "ASP Web HowTo" <asp_web_howto@p...>

Sent: Monday, November 19, 2001 10:22 PM

Subject: [asp_web_howto] Re: Links





> > Hi John,

> OK, thanks again for all your help and, yes, I do have another question!

> (sorry) I know that you are supposed to use Access databases but I donnot

> have that and was wondering if I could use a Microsoft Works database? If

> so, would I do anything different with a Works database and an Access

> database?

>

> Thanks,

> John

>

> >

> >

> >

> > ----- Original Message -----

> > From: "John Tarbell" <kmind711@a...>

> > To: "ASP Web HowTo" <asp_web_howto@p...>

> > Sent: Sunday, November 18, 2001 11:47 PM

> > Subject: [asp_web_howto] Re: Links

> >

> >

> > >> OK, i understand how to do the code with like the first name and last

> > name

> > > but i see on the links how it says like ?id=23 or whatever and when i

> go

> > > to the page it has a lot of things on the page but it never says like

> that

> > > the id=23 on the page. How is this done?

> >

> >

>




$subst('Email.Unsub')

>

>





----------------------------------------------------------------------



Subject: Re: Problem with using JScript and VBScript in One File

From: "Jason Salas" <jason@k...>

Date: Tue, 20 Nov 2001 08:32:08 +1000

X-Message-Number: 31



You should only have the page's language directive declared once.  If you

use both of these anywhere in the same script:



<%@language = "JScript" %>

<%@language = "VBScript" %>



...that will produce the error.  This may also happen if you use your script

as an SSI include, or have another script included within it.



Or, you could use inline scriptblocks, such as:



<script language="JScript" RUNAT="server">

...script goes here...

</script>



HTH,

Jason





----- Original Message -----

From: <anhdo@a...>

To: "ASP Web HowTo" <asp_web_howto@p...>

Sent: Monday, November 19, 2001 8:12 PM

Subject: [asp_web_howto] Problem with using JScript and VBScript in One File





> How would I change the following JScript code below to work with VBScript

> on my ASP document.  Since my VBScript already has <%@languague

> ="VBScript"%> how can I also use JScript too?

>

> I get the error: Active Server Pages, ASP 0141 (0x80004005)

> The @ command can only be used once within the Active Server Page.

>

> I want to modify the script below so that it no longer has the first line

> and I can embed it in one of my ASP documents?  How do I accomplish this?

> If you don't understand my question please email me at anhdo@a...

> Thank you!

> ----------------------------------------------------

>

> <%@language = "JScript" %>

>

> <%

>    var feedId = 62;

>

>    var refresher = new Date(  );

>    var refresherMinutes = refresher.getMinutes(  );

>    refresherMinutes = refresherMinutes - ( refresherMinutes % 5 );

>    refresher.setMinutes( refresherMinutes, 0, 0 );

>

>    var ctrl = Server.CreateObject( "SOFTWING.ASPtear" )

>    var newzsnap = ctrl.retrieve

> ( "http://www.lobbynet.com/ppc_center_deliver/" +

>                                  "deliver_articles.asp", 2,

>                                  "searchId=" + String( feedId ) + "&" +

>                                  "forceReload=" + refresher.getTime(  ),

>                                  "", "" );

>    var ctrl = null;

>  %>

>

> <%= newzsnap %>

>




$subst('Email.Unsub')

>

>







----------------------------------------------------------------------



Subject: RE: Problem with using JScript and VBScript i     n On e File

From: "Jason Salas" <jason@k...>

Date: Tue, 20 Nov 2001 08:44:15 +1000

X-Message-Number: 32



This is a multi-part message in MIME format.



------=_NextPart_000_009A_01C1719F.88EA9BE0

Content-Type: text/plain;

	charset="Windows-1252"

Content-Transfer-Encoding: quoted-printable



RE: [asp_web_howto] RE: Problem with using JScript and VBScript i n On e 

FileThis is probably because in VBScript all variables have to be 

continuous characters, and need to be declared by dimensioning them, and 

assigning their value as follows:



DECLARING YOUR VARIABLE IN JSCRIPT:

var feedId =3D 62;



DECLARING YOUR VARIABLE IN VBSCRIPT:

Dim feedId

feedId =3D 62



Just note that in VBScript, you don't have to call variables by 

"var...", and case-sensitivity isn't an issue.





HTH,

Jason





  ----- Original Message -----

  From: Do, Anh

  To: ASP Web HowTo

  Sent: Tuesday, November 20, 2001 6:49 AM

  Subject: [asp_web_howto] RE: Problem with using JScript and VBScript i 

n On e File





  I tried using VBScript with it but when I did I got an error at the 

line of code:  var feedId =3D 62;

  I'm not sure why myself, but I assume because the code was written 

specifically in JScript I need to have a script tag for the JScript..







    -----Original Message-----

    From:   Kyle Burns [SMTP:kburns@c...]

    Sent:   Monday, November 19, 2001 3:40 PM

    To:     ASP Web HowTo

    Subject:        [asp_web_howto] RE: Problem with using JScript and 

VBScript i n On e File



    It seems like this should also work in VBScript with minimal 

re-working.  Is

    there a reason this won't work?



    

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

=3D=3D=3D=3D=3D=3D=3D=3D

    Kyle M. Burns, MCSD, MCT

    ECommerce Technology Manager

    Centra Credit Union

    kburns@c...



     



    -----Original Message-----

    From: Do, Anh [mailto:Anhdo@a...]

    Sent: Monday, November 19, 2001 3:36 PM

    To: ASP Web HowTo

    Subject: [asp_web_howto] RE: Problem with using JScript and VBScript 

i n On

    e File







    Thanks!  I solved the problem.  The reason we are using two 

different types

    of script is that we are embedding a special client that we did not 

create.

    Since we originally created our page in VBscript we had to modify it 

to add

    this JScript code.

    The code worked for me when I did this:

    

---------------------------------------------------------------------

    <SCRIPT LANGUAGE=3D"JScript" RUNAT=3D"Server">







       var feedId =3D 62;

       var refresher =3D new Date(  );

       var refresherMinutes =3D refresher.getMinutes(  );

       refresherMinutes =3D refresherMinutes - ( refresherMinutes % 5 ); 



       refresher.setMinutes( refresherMinutes, 0, 0 );

       var ctrl =3D Server.CreateObject( "SOFTWING.ASPtear" )

       var newzsnap =3D ctrl.retrieve(

    "http://www.lobbynet.com/ppc_center_deliver/" +

                                     "deliver_articles.asp", 2,

                                     "searchId=3D" + String( feedId ) + 

"&" +

                                     "forceReload=3D" + 

refresher.getTime(  ),

                                     "", "" );

       var ctrl =3D null;

    </SCRIPT>

    <%=3D newzsnap %>














$subst('Email.Unsub')










----------------------------------------------------------------------



Subject: Re: new window

From: "Jason Salas" <jason@k...>

Date: Tue, 20 Nov 2001 09:07:00 +1000

X-Message-Number: 33



Here's a simple way to open a new window for a document, using JavaScript:



 <SCRIPT>

function open_window(url) {

mywin 

window.open(url,"win",'toolbar=0,location=0,directories=0,status=0,menubar=0

,scrollbars=yes,resizable=0,width=480,height=600');

}

</SCRIPT>





The script can then be called throughout the page using



FOR A TEXT LINK:

<a

href="javascript:open_window('http://www.somedomain.com/somefilename.asp)">

<font face="Arial" size="2" color="#000080">At this time of Thanksgiving,

what are we most thankful for?</font></a>







FOR AN IMAGE LINK:

<A

href="javascript:open_window('http://www.somedomain.com/filename.asp')"><img

src="http://www.somedomain.com/graphic.jpg">



HTH,

Jason





----- Original Message -----

From: <riley@i...>

To: "ASP Web HowTo" <asp_web_howto@p...>

Sent: Monday, November 19, 2001 9:23 PM

Subject: [asp_web_howto] Re: new window





> I see a few Javascript answers, which is what I found when I first started

> looking for this kind of solution.  You don't need to use Javascript, you

> can do it with vbscript.  I say this since it sounded like you wanted a

> vbscript-asp answer.

>

> here's some client side script:

>

> sub myPopup()

>

> dim myWindow

>

> with document.frmMyForm

>

> myWindow=window.open("popupWindow.asp","_blank","height=100,width=100")

>

> end with

>

> end sub

>

> Now, I usually call this sub on a button click event or an HREF (anchor,

> link) click event, but you can call it on a mouseover, text box change,

> whenever.

>

> You can also use ASP to generate this client-side script dynamically,

> which can come in really handy.  Lemme know if this works for ya, and good

> luck.

>

>

>

>

>

>

>

> >

> > This is a multi-part message in MIME format.

> >

> > ------=_NextPart_000_002D_01C1696B.F5A25C00

> > Content-Type: text/plain;

> > charset="iso-8859-1"

> > Content-Transfer-Encoding: quoted-printable

> >

> > You should some client side scripting there like javascript.  You can a



> > find a lot of the scripts you want at www.javascripts.com

> >

> > Enzo

> >   ----- Original Message -----

> >   From: Rob v. Osnabrugge

> >   To: ASP Web HowTo

> >   Sent: Thursday, November 08, 2001 10:24 PM

> >   Subject: [asp_web_howto] new window

> >

> >

> >   Hello,

> >   I'm looking for an (ASP) function, from which I can open another new 

> > ASP

> >   webpage, but with a given size and with parameters. Something like

> >   href=3Dxxx.asp?yy=3Da&zz=3Dc width=3D300 height=3D400

> >

> >   Thanks,

> >   Rob

> >




> > $subst('Email.Unsub')

> >

> >

> > ------=_NextPart_000_002D_01C1696B.F5A25C00

> > Content-Type: text/html;

> > charset="iso-8859-1"

> > Content-Transfer-Encoding: quoted-printable

> >

> > <!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.4522.1800" name=3DGENERATOR>

> > <STYLE></STYLE>

> > </HEAD>

> > <BODY bgColor=3D#ffffff>

> > <DIV><FONT face=3DVerdana size=3D2>You should some client side scripting

> 

> > there like

> > javascript.&nbsp; You can a find a lot of the scripts you want at <A

> > href=3D"http://www.javascripts.com">www.javascripts.com</A></FONT></DIV>

> > <DIV><FONT face=3DVerdana size=3D2></FONT>&nbsp;</DIV>

> > <DIV><FONT face=3DVerdana size=3D2>Enzo</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=3Dosnabrr@h... href=3D"mailto:osnabrr@h...">Rob

> 

> > v.

> >   Osnabrugge</A> </DIV>

> >   <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A 

> > title=3Dasp_web_howto@p...

> >   href=3D"mailto:asp_web_howto@p...">ASP Web HowTo</A> </DIV>

> >   <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Thursday, November 08, 

> > 2001 10:24

> >   PM</DIV>

> >   <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> [asp_web_howto] new 

> > window</DIV>

> >   <DIV><BR></DIV>Hello,<BR>I'm looking for an (ASP) function, from which

> 

> > I can

> >   open another new ASP <BR>webpage, but with a given size and with 

> > parameters.

> >   Something like <BR>href=3Dxxx.asp?yy=3Da&amp;zz=3Dc width=3D300

> >   height=3D400<BR><BR>Thanks,<BR>Rob<BR><BR>---<BR>You are currently 

> > subscribed to

> >   asp_web_howto as: <A 

> > href=3D"mailto:enzaux@g...">enzaux@g...</A><BR>To

> >   unsubscribe send a blank email to <A

> >   

> >

href=3D"mailto:$subst('Email.Unsub')">leave-asp_web_ho

> > wto-659864M@p...</A><BR></BLOCKQUOTE>

> ---<BR>

> You are currently subscribed to asp_web_howto as: jason@k...<BR>


$subst('Email.Unsub')<BR>

>

> </BODY></HTML>

> >

> > ------=_NextPart_000_002D_01C1696B.F5A25C00--

> >

>

>









---



END OF DIGEST






$subst('Email.Unsub')

Message #2 by "TomMallard" <mallard@s...> on Wed, 21 Nov 2001 05:28:16 -0800
In the checkbox code add a handler for onclick. In the handler function all

you need to do is set the radio button using the document object...



document.formName.radioName.click();



HTH,



tom mallard

seattle

----- Original Message -----

From: "Rainery, Kim" <Kim.Rainery@w...>

To: "ASP Web HowTo" <asp_web_howto@p...>

Sent: Tuesday, November 20, 2001 7:57 AM

Subject: [asp_web_howto] RE: asp_web_howto digest: November 19, 2001





> Hi

>

> I am wondering if anyone has ever done something with javascript where

they

> have two radio buttons and some checkboxes, the checkboxes are associated

> with only one radio button and if someone checks the checkboxes the

> associated radio should automatically become selected? any help would be

> appreciated.

> thanks

> Kim

>






  Return to Index