Search results for query: *

How would i select one value based on another? the table stores its value as "Y" or "N", but i want 1 or 0. if they were numbers, i could perform the operation much more easily. if anyone can suggest a better way to do this operation, i'd love to hear it because i'm running out of ideas here...

I need to use two recordsets from different sources. specifically, I query our main DB (ODBC) to get updated price information. In an access DB, i have some extended fields for the products, like length, width, and height. I need to have it update the pricing in the existing table and also...

I'm writing a program that ultimately will dump data into our old DB server (COBOL) using a 3rd-party ODBC driver. I have absolutely no problem with the SQL statements, but the server requires that you log on EVERY time. it pops up a window titled "GRANT and REVOKE Security," and there is no...

hi, i'm having a problem with this code objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.Mappath("loginlog.mdb") & "; Jet OLEDB:Database Password=" sqlString = "INSERT INTO Distributor (Company, Date) VALUES ( '" & login & "'...

Ok, i've looked all over and now i can't figure this out. I use a HFlexgrid to display records from a access database. first i tried using an ADODB recordset and setting the felxgrid's datasource to the recordset. then i tried using an ADODC control as well. the result is the same. if the...

I'm trying to integrate a web-based progrram into a VB6 program. basically, the VB program sends a ZIP code to my web program, and then the user selects some variables, and the web program outputs up to three options. The user then selects one and i need that data (a company and a price) to...

I have a new MSI (VIA KT266A Chipset) with a VIA onboard LAN. the Link and activity lights come on while the computer is booting, but after the windows 98 splash screen appears, they go off and the network will not work. Windows still recognizes that the card is present in the system, but the...

I am having a problem connecting to an ODBC source. Even if i put the username and password in the DSN, the system ALWAYS wants the L/P and pops up a box to do so. I want it to run a query while no one is here, so there is the problem. would there be anyway for a vb script (started from task...

This may sound way simplistic, but this SQL statement won't work SELECT *,CInt(Mid(Product,4,5)) AS Cap FROM LA WHERE Cap=30; I have absolutely no idea what is wrong...can anyone help me? thanks, Douglas

I use two different files depending on a session variable, but when i put the include tags into script, it writes the tags but does not include the files. what am i doing wrong? the code is pasted below <% if Session(&quot;P&quot;)=&quot;24&quot; or Session(&quot;P&quot;)=&quot;29&quot; then...

I have a server that we connect to that uses a Transoft U/SQL driver (it is a sco unix box). the driver works to link tables from access, but on one computer (win 2000) it will not link tables in access but it will work from excel. has anyone had a problem like this? what should i try? it...

I've used an array to hold Lengths, Widths, and Heights for a program, but i found that they're being stored as strings instead of number because they're being submitted frrom a form from textboxes. How do i get them to be numbers again? apparently CInt() doesn't work. thanks, DG

When i try to call a sub with one variable like Mysub(V1) it works fine, but when i use Mysub(V1,V2,V3) it tells me: Error: cannot use parentheses when calling a Sub. why? thanks

This may be a stupid question, but I'm trying to use a variable in an object name, how would i do this? I have buttons named Length1, Length2, etc. and their onclick event is LD(1), LD(2), etc., respetively. my code is posted below. any help woulld be greatly appreciated. Douglas <script...