Search results for query: *

Outer join table 2 should work.

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 tried it but it did not work. I though that would compare the returned value to the literal string company.

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

...p). Any idea what I'm missing here? (Yes I have RTFM'ed I'm just not getting it) Class Player code package draft; import draft.*; public class Player { String f_name; String l_name; String pro_team; String position; int player_id; public...

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

...the servlet. I can't figure out why. Note: I have pared the servlet code down to what you see to try to figure out the problem. Applet code: /* * Created on Jan 14, 2005 */ /** * @author Brian */ package Draft; import java.applet.*; import java.awt.*; import java.io.*; import...

...when I try this code: MdbFilePath = &quot;\\nt3\CARE\VCARE4X\DATABASE\FC01\vc40clin_IIS.mdb&quot; Conn.Open &quot;Driver={Microsoft Access Driver (*.mdb)}; DBQ=&quot; & MdbFilePath & &quot;;&quot; The application is running as a domain user. Everyone has full control of %TEMP% and %TMP%...

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

...MdbFilePath = Server.MapPath(&quot;DBs\mydb.mdb&quot;) Conn.Open &quot;Driver={Microsoft Access Driver (*.mdb)}; DBQ=&quot; & MdbFilePath & &quot;;&quot; I can connect to the database if it is on the web server but that is not an option here. The only thing I am doing is simple select...

Thought I would add... IUSR_SERVA has full permissions on %TEMP% and %TMP% on servA.

...Set Conn = Server.CreateObject(&quot;ADODB.Connection&quot;) MdbFilePath = Server.MapPath(&quot;DBs\mydb.mdb&quot;) Conn.Open &quot;Driver={Microsoft Access Driver (*.mdb)}; DBQ=&quot; & MdbFilePath & &quot;;&quot; I know it is a permissions problem but I can't figure out what is wrong.

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