The cLng was it. I thought that might be the problem but the DB was an integer and the value parameter in the form had no quotes when I started.
Thanks for the help.
var is not a value or anything. It is just in the output string I used. At the top you'll notice I loaded the variable company with the form value. The output shows that the value is loaded.
I have an ASP web page thet I changed to query from one DB to another. The code worked previously. The connection is fine and data is returned but highlighted if is failing:
<%
company = REQUEST.FORM("company")
response.write "form var =|" & company & "|"
Dim conn, strSQL, rsRes, ConnStr...
That was it. I had to explicitly set my classpath to get it to work. I now have a much greater understanding of what the classpath does. Thanks again for everyones help.
Ok. To test my classpath I compiled a known working source file in a directory on a different disk. It compiled successfully. Doesn't that indicate that the classpath is ok?
Thanks for the replies. Hopefullly this will relieve some of the soreness in my head (from banging it on the wall).
I only did the import when the problems first occured. I checked my classpath and the first entry is a period(current directory). That should handle the classpath issue. Any...
I have constructor Player and constructor Owner in their respective classes. In constructor Owner I have a method (addRosterPlayer)i need to pass an instance of constructor Player. I have imported the entire package into both but class Owner will not compile. The error is "cannot resolve...
Sorry guys and thanks for the patience. I thought I put it in the original post.
The only thing that shows in the textarea is the word Exception with a small box after it. I assume that this is a non-printable character. When I debug I get a few bits of human readable code in the draftinfo...
Background info. WinXP, Java sdk 1.4.2, Eclipse IDE
I have an applet that I am trying to communicate with a servlet. I have compiled both the applet and the servlets without error. When I run the applet I return an exception in the text area defined for the data returned from the servlet. I...
I am trying to access a database via the UNC. The short of it is I can write to and read from the directory using:
Set ScriptObject = Server.CreateObject("Scripting.FileSystemObject")
Set MyFile = ScriptObject.OpenTextFile("\\nt3\care\vcare4x\database\fc01\testfile.txt"...
Are you sure the other app is not opening the db in exclusive mode?
I shut down the app. Copied the database to a new name in the same folder and compacted it. I gave the new database the same permissions as the old database.
I thought that was what a virtual directory was for.
According to several places on the web you can access them.
Here are a couple of examples:
http://aspfaq.com/show.asp?id=2168
http://support.microsoft.com/?kbid=207671
Somebody must have it working....
I just can't figure out why mine...
I posted this to the ASP Forum and am waiting for a response but I thought I would respond to you.
I went away from a DSN because of the requirement to map a drive on the IIS server to create the DSN. I also read alot about the overhead involved in a DSN connection.
The queries will always be...
First.... I tried this using UNC but no luck.
Second... DSN connection requires mapped network drive. Don't know how to assure drive is available for IUSR so I gave up on that for now.
I posted this in the IIS forum but they told me this belonged here. I have read every site/FAQ/forum I can...
First.... I tried this using UNC but no luck.
Second... I don't think this belongs in the ASP forum but please let me know if I am wrong.
I have IIS 5.0 running on serverA. The IIS user is a local user (IUSR_SERVA).
I have an Access 97 DB on serverB that I need to query using ASP . I have a...
If I am reading them right what the manuals actually say is that the data is private to the session. The whole point of a global temporary table is that only the structure of the table is stored in the data dictionary. Each session can use that structure with their own data. This allows...
I created a global temporary table in a database that I do not own but have create table permissions on. I can access the table from within the session I created the table but other sessions (for the same user) cannot see the table.
session 1 Logs in and executes create table:
CREATE MULTISET...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.