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.

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?

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

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

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

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

Someone has handed bunch of my Microsoft SQL queries. They work fine, except the ones that refer to other queries. For example: SELECT Equip FROM qryStorage UNION SELECT Equip FROM qryBrokenStock ......... where qryStorage and qryBrokenStock are other MS Acces Queries. I am turning these...

How does one make the "Save As" dialog box appear with a JSP when they want to send the user a file? I have a tab delimited text file (that I have renamed "report.xls") that I would like them "Open With" the Excel program. Even though I renamed the file, it still sends the text to the browser...

One of my JSPs writes a file. My declaration is... FileWriter fw = new FileWriter("report.xls"); The file get created in the bin folder of Tomcat and not the folder where my JSPs are. Does anyone know how to control where new files are created?

I'd like the user to be able to type in the text box area of my combo box, and have it autofill with a value in the dropdown list. Right now I'm using the standard "<SELECT>" combo box tags and the user can't enter any text. Thanks in advance.

I have Tomcat 4 installed the example servlets are compiling when I visit "http://localhost:8080/" and then the examples. When I open my own JSPs, they display in the browser but aren't compiling. I think the problem has to do with my web.xml file (or lack there of.)

Once you have gotten your JSPs the way you want them (and tested them in "http://localhost:8080/folder/" environment, how do you make them a part of a web application? The "web.xml" file has been undaubting to figure out. Are there any good tutorial sites out there?

We have a server here at work that is Windows 2000 Server Advanced edition. The problem is that we are having it host two seperate web sites developed with different DNS and IP addresses. ONE site is to be served out strictly with W2K Server IIS, which was developed with a lot of ASPs. This...

I installed Tomcat 4 on a computer that is connected to the Internet with a static IP. Although 2000 Server is my OS, I don't want to use IIS to serve the pages. I can successfully view JSPs locally with Tomcat "http://localhost:8080/project/page.jsp" and am ready to serve these pages out to...