I have a problem with my INSERT query, I have tblDueDates, tblClient and three main forms.……..but I get errors when trying to insert payments. I have tblClient and tblDueDates and 1.frmDueDates, to insert and display the due dates for the payments ,
2.frmPayDateList in order to display the Due Dates of all clients in a list according to their due dates and 3.frmClientsPayedrecord, to see the payments of each client after the user clicked on the ‘payed’ button on the 2.frmPayDateList form. Form frmDueDates and frmClientsPayrecord are linked to tblDueDates.
But I get an error when clicking on that ‘payed’ button on the frmPayDateList. I use an INSERT query to insert the payments into that one table tblDueDates and also it should avoid duplication with this query and it’s where clause!!!!
I want to insert 2 values in to a database WHERE the userID=1..... The SQL below shows what I have done so far, but I want it to enter these 2 values into the row where userID column equals 1.
I am reading about 200 records from dbf file in ASP code and inserting into a table. I fetch the records in a recordset and in the recordset loop I have to insert it into the SQL table.
How should I insert the values?
1) Should I use query in ASP page
2) Or call stored procedure (passing each record parameter) for inserting, 200 times in the loop.
Also what type of cursor should be created, Client side or Server side.
Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. It points to the "set rs2=db2.execute(sql)" line
The sql statement looks like this: Insert into tblInCart(user, item_number, qty, price, description, taxcode) Values('EXMPLE', '100BLUERASP', 1, 3.99, 'MIX COCKTAIL BLUE RASP', 'N')
The user, item_number, description, and taxcode fields are text, the qty field is integer, and the price field is currency. The rs2 recordset was previously used for a select query, which works fine, but it is closed before this happens.
Here is my delima im hoping you can help me with. My code currently works fine. However I want to make some modifications to it to get that best possible outcome for my client(Taxi company). Here is the code logic:
The code code currently has one text field which takes a number(Taxi number) and returns all calls assigned to the taxi number inputed in the text field and returns all, canceled, and pickedup calls by said taxi number within the CURRENT DAY. Im trying to find out how i can input a taxi number and get returned calls from PREVIOUS DAYS also preferablly going back one WEEK to a MONTH. I hope im clear. If not please inquire for further clarification.
I have problem inserting value with special characters such as email address: anne.walker7@btinternet.com and creditcard:1111 2222 3333 4444 number with spaces inbetween the numbers as these special characters are reserved in MS Access. Any help
we have a query in a stored procedure that is called once a form has been submitted which inserts form data into our database. the problem we are having is that when a user refreshes the page , another record is added to the database. a way to prevent this from happening.
How would I insert this code into a .HTML document rather than a .ASP document.
<% Set MyFileObj = Server.CreateObject("Scripting.FileSystemObject") Set MyTextFile = MyFileObj.OpenTextFile(Server.MapPath("content.txt")) WHILE NOT MyTextFile.AtEndOfStream Response.Write(MyTextFile.ReadLine & "<BR>") WEND MyTextFile.Close %>
I am trying to set up a staff update page for a local school and have set up a database to record it. I know the database works because I can populate it and display the content. When I went to write the insert statement I get an error that i am unsure how to solve. This is the statement. Code:
I have a form that if a user selects a certain option from a dropdown list a checkbox will appear. This checkbox references information from another table and then multiplies a figure before it is submitted (well, that's the theory anyway!)
I can't seem to get the multiplier to work. Can someone please give me some advice to this? I've included some simplified code that concentrates on the areas that I'm having difficulty. Code:
I'm a beginner with asp but i have an asp page that returns all the names and email addresses of people that i have stored in my database.It returns it in table format.This is all working fine - im using an ms access database. heres the code: ...
i have a query that runs fine in oracle, but when i try and run it through my code i get an error :
Microsoft OLE DB Provider for ODBC Drivers error '80040e31' [Oracle][ODBC][Ora]ORA-01013: user requested cancel of current operation
/test/WO_Metrics.asp, line 129
i know that it has to do with the way my query is coded, i think maybe with the nested query. because it worked fine before i put the nested query in. is there a special way to handle nested queries in aps? Code:
My code retrieves a username and a password from a form. Then this information is compared to some usernames and passwords that are stored in a database. The important thing here is that the comparison must be case sensitive meaning that "passWord" is not the same thing as "password"
I have this code, working fine in access 2003
SQL = "SELECT * FROM users WHERE StrComp(username_column,'" & entered_username_in_form & "',0) = 0 AND StrComp(password_column,'" & entered_password_in_form & "',0) = 0"
but get the following error when I run it against my sql 2005 database.
[Microsoft][SQL Native Client][SQL Server]'StrComp' is not a recognized built-in function name.
I don't know the corresponding t-sql for the query.
I am running a querry on an access database and have set the number of records/page displayed at 20. if there are more than 20 records returned, then 1st page will show the first 20, the next page will show next 20 and so on....
The trouble:
the count of total records displayed is correct and the first page is displayed correctly. But when i click on *Next* to go to the next page, all the records of the database get displayed (not the 2nd page of records from the query).
In Access you use "*" + [passed variable] + "*", + can be replaced with & Calling a parameterized query in Access requires % be used in place of *, however, all that I have read show dynamic SQL passed to Access:
WHERE [some column] LIKE '" & ASPvar & "' % ORDER BY ...
However, my call is similar to:
conn.qMyLookup strVar, rs
If I modify the query in Access to:
"%" & [passed variable] & "%"
I get all records. If I only put it at the end, as suggested, I only get matches at the end, not throughout the column. Code:
Our graphic designer has just finished redeveloping our website. On the site, we use SSL to secure the area where a user enters their personal information to order items from us. (we do not do many transactions - maybe 1 per day...) We are a log home mfg company so they would only order plan books, maybe a video etc...
When the user clicks "Submit Order", we want to encrypt each data item (because of new legislation governing customer personal info etc...) and write a record to an access db. From here it will be imported into our Customer DB leads database...
I do not use ASP but program in VB 6 and Access 2000. ASP looks similiar in many ways...
Does someone have a good ASP script for encrypting data? And, if so, is it fairly strong encryption?
Also, is there any trick to writing an "insert" SQL script in ASP or is it exactly the same as I would do in VB or Access? Maybe someone has an "insert" script handy they could pass along including the command to actually execute it?
that's shortly the way i'm inserting new records. using mysql and asp functions.
The prob is that inserting only one record every time. if i got data for 3 records how can i make it at once to add 3 new records in some given order into the db
What is the best way to see if a record has inserted correctly into the datase in ASP? Also, how to tell the user what the error is. I am inserting like this with the ADO command object: Dim sInsert, objCmd set objCmd = Server.CreateObject("ADODB.Command") sInsert = "sp_ADS_Insert_Driver_General_Data " on error resume next With objCmd .ActiveConnection = oConnEnergy .CommandText = sInsert .CommandType = adCmdStoredProc .Execute , , adExecuteNoRecords
Application X has three screens. The user captures information on screen one and then clicks a navigation button to go onto screen two.He does the same on screen three. At the bottom of screen three is a submit button. When this button is clicked the system does some calculations with the information that is supplied and then uploads all the info that was captured on the screens to the database.
Should the data be uploaded to the database all on one go when the user clicks the submit button or should it be uploaded after each screen - ie when the user clicks the button on Screen 1 the data is uploaded to the database and then screen two is displayed.
I have a column call UserDate and it's properties are this : varchar(50) . I have a function which updates the column with todays date. for some reason, if I manualy give the value to be inserted a value of '10/10/2006' or use date() it inserts a value of 0 if I give a value of 4 to be inserted it works?
I have been working on a project for 2 days and this is the last piece to get it to work, can anyone point out where I'm going wrong. P.S I have tried giving the colum a date format but unfotunately the format is american and I need it in english to compare with something else I'm working on.
I'm getting a syntax error when I try to run this SQL Insert statement, can anyone tell me what might be wrong? Before I was getting a data type mismatch error then I removed the ' quotes around the intPhone variable. The error occurs on the line after the SQL statement.
