Search results for query: *

I want to use the Date format in Access 2002 for a list of dates. They are easier to sort than strings. What format should I use? Simple date? What should the JDBC SQL statement look like to run a query on the date? Thanks.

typo above.... #2005-12-31# should be #2005-31-12# HEEEELP ;)

Trying to create an SQL statement that queries the simple date format (mm/dd/yyyy) in Access 2002 (using ODBC driver)... Have tried everything!!! Best guess has been: SELECT * FROM TABLE WHERE DateField = #2005-12-31# JDBC just doesn't recognize the format and ignores the statement! There...

Has anyone encountered this? Does anyone know how to fix it?

The stacktrace on Tomcat for this error doesn't show anything useful. Is there any way to pinpoint exactly what Java was attempting to use the Winsock32 .dll for? If I knew what Java was attempting to do when it made that call to the OS, I might be able to come up with a workaround. help!

Does anyone get this error? What causes it and how do you fix it?

We have two websites on one Windows 2000 Server box. Both of them are SSL. One is ASP oriented and the other is JSP. The JSPs are being redirected to Tomcat with the ISAPI_redirector2 file. When too much traffic is on the JSP site, there is the error java.net.SocketException: Software...

If what you say is true, then Access is forced to write a temporary file every time a join is created. Why can't I turn my 2 gigs of RAM into a RAMDrive? Call it h: or something. Is there any way to force the temporary files created in Access to be written to a specific drive? If so, I will...

Hello. I have a huge SQL statement that joins 13 tables together. This statement is part of a query builder that I wrote to search a 3rd normalized schema. ANYWAY... When it executes, I get a "[Microsoft][Access Driver]Not enough temporary drive space." error. I have 2 Gigs of RAM in my...

Very helpful.. Thanks.

Exactly. I would like all cell manipulations possible (including highlighting, showing gridlines, etc...) that can be manipulated from the value inside a cell. For example.... in HTML <b>Hello</b> will bold the Hello. Does anyone know of attributes that can be applied to the value of a cell...

Does anyone know how to format tab delimited plain text imported into Excel? For example.... how would one make the following bold or change the font size.... etc.... COLOR<tab>QUANTITY<tab>WEIGHT<CR> red<tab>3<tab>3 lbs<CR> green<tab>5<tab>5 lbs<CR> blue<tab>8<tab>3.5 lbs<CR> Are there any...

I've googled for this one... seems lots of people have this problem but not a lot have answers. My JSPs will hang intermitently. It's hard to tell if the database driver is causing the problem because it happens while my Access DB queries. I'm putting a commercial type III DB connector on...

Thanks Leslie. Does anyone else have any suggestions? I have a lot of LIKEs to OR and am looking for less keystrokes than mentioned.

I would like to query for items similar to SELECT crayon FROM box WHERE color IN ('red', 'blue', 'green') However, I instead I would like to query for LIKE... ORing them as above. SELECT crayon FROM box WHERE color LIKE IN ('r*', 'b*', 'g*') Is the statement above right?

This should be easy for someone who has been writing SQL statements for awhile. I need to query for information in a table that looks similar to this: SELECT field1 FROM table WHERE field2='123' OR field3 LIKE '456*' OR field3 LIKE '678*' You can see the delimma with the statement. Field2...

I have a jdbc connector and need to set the classpath to the director I put it in. Anyone know how to set it?

This should be easy for someone who has been writing SQL statements for awhile. I need to query for information in a table that looks similar to this: SELECT field1 FROM table WHERE field2='123' OR field3 LIKE '456*' OR field3 LIKE '678*' You can see the delimma with the statement. Field2...

Can anyone help?

I really don't understand you. Maybe 50% of what you say... I have written Java Server Pages and am accessing an Access database through a JDBC connection. JSP is an alternative to ASP for creating dynamic webpages with DB content (in case you didn't know.) Tell me.... what exactly does the...