Search results for query: *

yeah, it makes sense to use the underscore, I was just trying ot keep our standard part naming convention, which goes by eg. 0304-102. I am already working on a work around to just name the tables with an underscore as you suggest and have the code in ASP change the underscore to a hyphen for...

No strsql = "create table " & workweekwafer & " (stepno int(5))" does not work, it gives me the error. Any other Ideas?

I tried that [], I had typed it in , but I guess with all the editing to get the problem across, I must have deleted it by accident. But the [] does not work either. If I use Navicat to create tables in MySQL I can create a table with a hypen in the name, so it should not be an issue, it's...

Ok the I can use chr(45) to insert a hyphen , but I still get the same error.

Here is the code: querystring = "Create Table " & workweekwafer & " (stepno int(5))" Set RS = Conn.Execute(querystring) workweekwafer = 0304-102 I get this error Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [MySQL][ODBC 3.51...

got it. Now how can I use that if I have several parts in the table but still many entries per part and I still want the last entry for each part. Sorry I should have mentioned it before. Just to be sure, LastEntry is the command I use, not the last entry value. I have never seen it before...

Lets say we have a part which is tracked through several steps. so the table has records with the same part number, but different entry IDs. When I create the form it displays all the entried for that part number, I just need it to display the last record for it. The records are already in...

thanks I tried it but I still get the same error. Microsoft VBScript runtime (0x800A01A8) Object required: 'tblIncoming_Clean' /spectra/TMPnlagalbbyc.asp, line 109 the problem is not that it does not open the record or connection to the table. The problem is that I assign the table name to a...

the DB design Tables - step_list list of table names, one table for each of the steps in our process. - tblIncoming_clean a step, so in the DB there is a table named tblIncoming_clean to collect information for that step The idea is to loop through the...

I will post it here, but if it is too much we can find a different way. I appreciate the help. I've added comments to what I am trying to accomplish. I have gotten a different version of this to work, but in the page there is code for each individual table to be displayed, if any changes are...

Don't worry non taken, I don't consider myself and expert and I am always interested to learn more. Can I e-mail a text file?

I already have a recordset open statement at the top of the page. Do I need to have the loop create the recordset everytime? This page will do this loop for 34 times for diferent tables and up to 20 times for different parts to track, would that cause problems opening recordset so many times...

I am been trying to figure this out for a while now and I have not found a solution. I'm sure it will something simple, but I want to move ahead with the project so I will ask the smart people of this list. -I have a DB field that lists table names. Using ASP I tell it Step_table_name =...

Where can I get a pre-built automobile database? Just make, model, year and engine size description, the basics to select or search for specific automobiles. I began to put one together but figured it would be easier to buy one or if someone has one they can share. I just need the tables so I...

I am recording off a TIVO unit and when it is playing on the TV it looks great, but once it is captured the quality is about half as good. Any one has any setting used that will give me good quality? Also what is the best way to export to get good quality, let's say for a 30 minutes clip to a...

I got another motherboard, the same as the one in there now. It works now, there must be something up with the motherboard...

I installed a new motherboard with a 1.7 AMD, since then when I capture it does not capture the sound only video. Let's go down the list 1.I can hear sound when Premiere is recording. 2.The capture card(all-in-wonder) is connected to the soundcard via the internal connections 3. I also...

Try using cleanerEZ that comes with Premiere and convert to to Quicktime. I tried avi, real media. Quicktime gave me the smallest and best quality.

I've seen this before where several small browser windows were opened on teh desktop to a specific location, each window contained a portion of a big picture and all the browser windows are arranged to form the big picture. Any one know how to do this?

Rookie move, I guess when trying to export using Cleaner 5 I need to select the clips.