Web Development

Re: Replace " ' " symbol in my code

3-Mar-03 4:21

To place a single quotation mark into database, just repeat it, e.g. to use "O'Brian" in your SQL statement, you should replace it with "O''Brian". You do not need to do that though if you are using ADO's Recordest("field") = "O'Brian"

Philip Patrick
Web-site: www.stpworks.com
"Two beer or not two beer?" Shakesbeer

Black Cat3-Mar-03 4:29

Black Cat

3-Mar-03 4:29

It looks like you probably used the variable surname as part of a SQL statement. With SQL, the value has to be quoted by ' such as:

<br />
select * from myTable where name = 'John Smith'<br />

If the name value itself contains a ', the SQL statement is invalid:

<br />
select * from myTable where name = 'John's Smith'<br />

What you need to do is replace ' with two consecutive ', like the following:

<br />
select * from myTable where name = 'John''s Smith'<br />
<br />
CStr(Replace(Trim(surname), "'", "''"))<br />

Good luck.

back to the top

Jh32-Mar-03 22:13

Jh3

2-Mar-03 22:13

Hi
how do you create a link to the top of your page from down under? i know the bottom part should look something like href = "#tothetop", but the top part?

tx

Re: back to the top

antbates3-Mar-03 4:13

3-Mar-03 4:13

At the top, you need something like:

<a name="start">This is the start of the page</a>

Then at the bottom:

<a href="#start">Go back to the start</a>

Hope this helps

Working with Sockets

Ghasrfakhri1-Mar-03 21:25

Ghasrfakhri

1-Mar-03 21:25

Hi Who Can I work With Sockets in ASP?

Iman Ghasrfakhri

Re: Working with Sockets

Philip Patrick3-Mar-03 4:24

Question about fieldset tag of HTML.

3-Mar-03 4:24

AFAIK, there is no such interface to work with sockets. You should build either your own COM object, ot use ServerXMLHTTP of XML (if it is suitable for you)

Philip Patrick
Web-site: www.stpworks.com
"Two beer or not two beer?" Shakesbeer

George21-Mar-03 21:17

Re: Question about fieldset tag of HTML.

1-Mar-03 21:17

Hi, everyone!

I think the function of fieldset tag of HTML is just adding
a frame around a form. Am I corrrect? Does the tag have some
other functions?

Thanks in advance,
George

Jonavis1-Mar-03 22:22

Jonavis

1-Mar-03 22:22

George (me again)

basically,...thats pretty much its function, but to put in a better way...the purpose of the FIELDSET tag and its complementary tags is to supply context with logical groupings of form elements (personal info on one block, credit card info in another and so on).

Hope this helped you out.

CYA,
Luck,
Jon

GET TO KNOW ME

Re: Question about fieldset tag of HTML.

George21-Mar-03 22:24

Question about <legend> tag of HTML.

1-Mar-03 22:24

Thanks, Jonavis buddie!

George

George21-Mar-03 15:30

Re: Question about <legend> tag of HTML.

1-Mar-03 15:30

Hi, everyone!

What is the funtion of <legend> tag of HTML? I
have searched a lot of help but they still makes
me puzzled.

Who can give me a simple explanation? Better with an
example.

Thanks in advance,
George

Jonavis1-Mar-03 19:29

Jonavis

1-Mar-03 19:29

Hey George...

the <legend> tag, is basically designed to save you some formating and time..

this tag works along with the <fieldset></fieldset>, giving a small description to each input, textarea, select, button, radio or checkbox in a <form>

example:

<form method="post" action="here.asp">
<fieldset>
<legend align="right">
Legendo goes here
</legend>
<input type="TEXT" value="HERE">
</fieldset>
</form>

just paste that code in an html page, and start playing around with the alignment, tables etc..
but thats basically it.

CYA
luck
Jon

<a href="http://www.radiostatic.net/jon/index.html" target=_new>GET TO KNOW ME</a>

Re: Question about <legend> tag of HTML.

George21-Mar-03 21:17

Easy Question About ASP/ADO

1-Mar-03 21:17

Thanks, Jonavis buddie!

I have just posted another question about
fieldset tag of HTML. Please help me out.

Cheers,
George

Roger Wright28-Feb-03 9:22

Roger Wright

28-Feb-03 9:22

I'm rebuilding a static HTML site to use ASP, and to populate the content of each page from a database. If I use a config.asp file to create a database connection, then #include it in all the site's pages, will it create a new connection each time a page is loaded, or will it reuse the same connection for all pages? What I'm attempting to do is to create just one connection, created when a page requiring it is first visited, but to make that connection persistent and available across all pages visited during a single session. Recordsets will be created and destroyed by each page as needed. What's the best approach to this?

It is ok for women not to like sports, so long as they nod in the right places and bring beers at the right times.

Paul Watson, on Sports - 2/10/2003

palbano28-Feb-03 12:22

palbano

28-Feb-03 12:22

If your database is SQL Server don't manage the connections the DTC does that for you by pooling database connections.

So just get a connection in your code when you want one and release it on the first line of code after your done with it

var conn = Server.CreateObject(....);

... do ur db io

conn.Close();
conn = null;

... do the rest of ur page

"No matter where you go, there your are..." - Buckaoo Banzi

-pete

Roger Wright28-Feb-03 21:11

Roger Wright

28-Feb-03 21:11

Sadly, the hosting service doesn't support SQL Server without an additional charge, and this site is for a charity that can't afford it. On the bright side, using an Access DB, by stuffing the connection object into the global.asa file I seem to be getting lucky. I haven't started constructing recordsets yet, but it hasn't choked on opening the connection. The connection object seems to be accessible from all the pages, as well. I think I may be on the right track here - wish me luck! Big Grin | :-D

It is ok for women not to like sports, so long as they nod in the right places and bring beers at the right times.

Paul Watson, on Sports - 2/10/2003

palbano1-Mar-03 20:20

palbano

1-Mar-03 20:20

You might want to research that a bit. I don't believe that your approach is recommended. I think it will actually work but it won't scale since all your requests will block on access to that single connection object.

I think a search on msdn.microsoft.com for keywords ASP ADO Access MDB will find several articles discussing this isssue.

"No matter where you go, there your are..." - Buckaoo Banzi

-pete

Does Administrative Privileges needed to Download and Install and ActiveX Control Embeded in a WebPage?

Roger Wright2-Mar-03 3:05

Roger Wright

2-Mar-03 3:05

You're right. I searched through the PSDK docs and found what I need; unfortunately it doesn't work. According to the docs, creating an object in global.asa with session scope makes an object that is accessible from any page visited during a session. They even use a ADODB.Connection as an example! But when I actually try it (I copied the code and pasted it in my .asa file, changing only the name of the connection), it fails every time. The actual failure occurs when opening a recordset. Again following the PSDK example for opening multiple recordsets on a connection, I tried both the rst.Open and conn.Execute techniques given. Neither works, and the message reports that one or more required parameters is missing. The Recordset docs state that the parameters are all optional, though I did provide a SQL string to define the recordset, and the name of the connection object to use.

Back to square one, as always when I try to make anything work from the MS instructions... Frown | :(

It is ok for women not to like sports, so long as they nod in the right places and bring beers at the right times.

Paul Watson, on Sports - 2/10/2003

Vasudevan Deepak Kumar28-Feb-03 3:34

Vasudevan Deepak Kumar

28-Feb-03 3:34

Hi,

I have the following doubt. I have an ActiveX Control embedded in one of my webpage, with a valid CodeBase from where the browser can download the CAB,unpack it, verify with Microsoft Authenticode and install. All goes well with my logon account as it has administrative rights.

But if I try on a different machine, and if the account does not have administrative rights, I think installation fails...

Does ActiveX Controls installation from webpage need Admin Access for the first time? Or is the above observation wrong and am I doing some other mistake in configuration?

Please advise...

Deepak Kumar Vasudevan
http://deepak.portland.co.uk/

Re: Does Administrative Privileges needed to Download and Install and ActiveX Control Embeded in a WebPage?

Philip Patrick28-Feb-03 20:47

28-Feb-03 20:47

I don't think so, but check the browser settings on that account, maybe ActiveX disabled there?
Also you can try to navigate to some Flash site (http://www.macromedia.com[^] for example) and see if Flash installs automatically (since it is ActiveX as well)

Philip Patrick
Web-site: www.stpworks.com
"Two beer or not two beer?" Shakesbeer

Get Server Info

antbates28-Feb-03 2:10

28-Feb-03 2:10

Hi all,

I need to get some information about a specfied remote server using ASP. Does anybody know how to do this?

Thanks

Anthony

Re: Get Server Info

antbates28-Feb-03 6:10

28-Feb-03 6:10

All,

If anyone could tell me how to check if another machine is running IIS, that would be great also.

Thanks again,

Anthony

Re: Get Server Info

Philip Patrick28-Feb-03 20:52

28-Feb-03 20:52

To gather information about machine where you execute your ASP code, you can use WScript object. Look for a good example here:
http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=8205&lngWId=4[^]

antbates wrote:
If anyone could tell me how to check if another machine is running IIS

It already has IIS,if you are executing ASP code, not? Smile | :)

Also forget about network in ASP. You cannot access any network resources (unless you change access rights for the default internet guest account)

Philip Patrick
Web-site: www.stpworks.com
"Two beer or not two beer?" Shakesbeer

Re: Get Server Info

antbates3-Mar-03 4:05