|
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
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
Hi
Who Can I work With Sockets in ASP?
Iman Ghasrfakhri
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
Thanks, Jonavis buddie!
George
|
|
|
|
|
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
|
|
|
|
|
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>
|
|
|
|
|
Thanks, Jonavis buddie!
I have just posted another question about
fieldset tag of HTML. Please help me out.
Cheers,
George
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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!
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
|
|
|
|
|
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
|
|
|
|
|
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...
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
|
|
|
|
|
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/
|
|
|
|
|
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
|
|
|
|
|
Hi all,
I need to get some information about a specfied remote server using ASP. Does anybody know how to do this?
Thanks
Anthony
|
|
|
|
|
All,
If anyone could tell me how to check if another machine is running IIS, that would be great also.
Thanks again,
Anthony
|
|
|
|
|
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? 
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
|
|
|
|
|
Maybe I should have explained myself more clearly. I am on Machine A, running an ASP script on Server B, and need to check if Machine C has IIS. What I have done is to make a component in VB which uses NetServerGetInfo. As you say though, it doesn't work very well due to permissions problems.
Thanks for your help.
|
|
|
|
|
your looking in the wrong place..
From what I've gathered, considering Im a frequent user here at Code Proyect, all you'll find here are legal codes and sources....but...you should look around www.astalavista.com,...look for scanners...
There you'll find applications that can preform these tasks..cuz I personally havent heard or seen of a way of reading from another server through web-enabled applications...
http://www.astalavista.com/archive/
luck,
Jon
X-ZD Designs
|
|
|
|
|
I have no experience with HTML, but I have a task that requires to start an application from an HTML page. I have tried to use MC FrontPage to create a hyperlink liked to my application, but Explorer opens a dialog " Download or open .....". How can I avoid this dialog? Or if anyone knows better way to do it? Thank you
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
