Search results for query: *

Never mind, I figured it out... had to wrap Class.forName in a try...catch block. That's all it took.

When I attempt to compile the class below, it returns this error: C:\...\classes\northwind>javac Employee.java Employee.java:11: unreported exception java.lang.ClassNotFoundException; must be caught or declared to be thrown Class.forName(DRIVER); ^ 1 error...

use a union query to create the recordset select field1 from table1 where field2 like '%red%' union select field1 from table1 where field2 not like '%red%' get it? only catch - if you order the table you lose your ranking. there is a way around it but involves using sql to create temporary...

You can do a replace but you gotta use a regular expression. You can see the syntax of the command at this website: http://209.55.107.62/javascript/string.htm#1194258 p.s. that is the Netscape Javascript 1.3 documentation hosted on my machine at home using my DSL connection so don't expect...

Be careful about writing HTML code from your dll. When your client decides he wants a red font, you don't want to have to recompile your dll. In general however, if you want to access the ASP built in objects you have four options: 1. Use ScriptingContext (bad) 2. Use ObjectContext (good) 3...

To create the link, use code like this: Do while NOT oRS3.EOF [tab]Response.Write &quot;<tr>&quot; [tab]Response.Write &quot;<td>&quot; & oRS3(&quot;Style&quot;) & &quot;</td>&quot; [tab]Response.Write &quot;<td>&quot; & oRS3(&quot;ArtistName&quot;) & &quot;</td>&quot; [tab]Response.Write...

Heres an idea. I just threw this code together but heres the gist of it... 1. Display the wait message 2. Write the html of the table you are building to a file on disk 3. When the page is finished processing, redirect the user to the html page on disk. <%@ Language=VBScript %> <% Option...

Hey Nick, Check out this article. I think it will help. http://www.asptoday.com/articles/20000317.htm

Ooops, forgot to clean up after myself. At the bottom of the ShowPage routine, add the lines of code: Rs.Close Set Rs = Nothing I turned this into an FAQ, you can see the better code in the FAQ section.

This question gets asked so many times here, I decided to put together a VBScript Class that will allow people to page a recordset. Here's the code and a page that will do it, just copy paste it into your favorite editor and start experimenting. You can definitely make the table prettier and...

Guestg is absolutely right.&nbsp;&nbsp;IE will try its best to URL Encode the URL for you.&nbsp;&nbsp;Netscape doesn't.&nbsp;&nbsp;If you have any spaces or special characters in your URL, Netscape chokes... and kicks that ugly error you describe.&nbsp;&nbsp;Use Server.URLEncode on any...

What type of Database are you using?&nbsp;&nbsp;If it is SQL Server, use the CONVERT function to convert the date into the format you want.<br><br>See Books Online for more info on CONVERT.<br><br>You will probably want to use the style 106 which will convert to &quot;dd mon yy&quot;<br><br>Most...

Put a hidden form element in your form which indicates the name of the form and use Select...Case to determine which stored procedure to run based on that form element.<br><br>Dim Rs&nbsp;&nbsp;&nbsp;'recordset<br>Dim dsn&nbsp;&nbsp;'datasource<br>Dim sp&nbsp;&nbsp;&nbsp;'stored procedure<br>Dim...

Your connection string looks like a witches brew of parameters.<br><br>1. Where's your username and password in the connection string?<br><br>2. Why are you putting the driver and the DSN in the same connection string?&nbsp;&nbsp;If you've already set up DSN, you shouldn't need to also specify a...

A quick rundown of three ways to connect to a database<br><br>1.&nbsp;&nbsp;ODBC Manager<br>Enter all configuration information through the ODBC manager and the ODBC driver.&nbsp;&nbsp;Connect to your database like this:<br><br><FONT FACE=monospace>&quot;DSN=Northwind;&quot;</font><br><br>2...

I can think of three ways to do what you ask:<br><br>1. Format it with your SQL statement.<br>Not sure about the syntax for MS Access JET SQL (I use SQL Server).&nbsp;&nbsp;In SQL Server it's CONVERT (data_type[(length)], expression [, style]).&nbsp;&nbsp;To convert to US English, you would set...

I don't think &quot;GO&quot; is a valid keyword when you are passing the statement thru ASP.&nbsp;&nbsp;In fact, I'm pretty sure of it.<br><br>If you want to use the &quot;GO&quot; keyword you have to make your SQL statement into a stored procedure and call the stored procedure.<br><br><br> <p>...

Write the link to the page with JavaScript...<br><br>&lt;Script type=&quot;text/javascript&quot;&gt;<br>document.write (&quot;&lt;A HREF='&quot; + zip + &quot;.htm'&gt;Link&lt;/A&gt;)<br>&lt;/Script&gt; <p> Jeff Friestman<br><a href=mailto: > </a><br><a href=...