table 1 is a cart
table 2 is customer details
table 3 is customer item buy item details
table 1 is let the customer buy their thing in here.
after he check out all the table 1 data will go to table 2 and table 3.
now my problem is how did it doing.
i using The SELECT INTO Statement but got error
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'a From cart where cus_id='2'' at line 1
/admin/order_details.asp, line 5 Code:
I have an ASP script running on the server that generated a PDF file for me on my server. Now, before I return to the client, I want the script to copy the file to a different location (on a different server). Can someone tell me how to code the file copy in ASP?
i m dealing with a problem i want to copy a FILE from some SPECIFIC URL to my server through my ASP code....can any1 help me in this regard ..i ve no idea doing this...FILESYSTEM OBJECT just support the physical files
is it possible to copy the value from fields in form1 to fields in form2 without submit the form??form1 and form2 are in the same page. if it's possible hoe to do that??
Anyone know a way to copy the contents of a recordset to a disconnected recordset and add a new column? The new column will be used to order the disconnected recordset.
My website users are copy pasting text from ms word docs and some of the characters are stored in the database differently. for example the characters look like • . my first doubt is > Is this allowed to do if yes, how can we get this fixed.my appl is asp and vbscript
i want to know that is it possible to copy from a word document and paste it on to a textarea on a asp page. when i do it normally bullets are not paste as it is . it is changed into different symbol( inverted ?)
i need to copy all the records in a database to a totally new and empty database n i try my code in sql analyser it runs perfectly but when i move to an asp page the process cannot perform... here is my code INSERT INTO attandence (company_code, data_serial_no, sign_in1, date_stamp, serial_no) (SELECT * FROM employee_att) is it syntax error or logic error??? the table structure for both is the same
i want to copy all records on table1 and append it to table2 , so how can i do thi throw asp? , by the way the 2 tables is not the same data , for example i want to add balanceid column into accountid column from the other table , and like this.... so whatz the asp code for this move i hope u can put for me a good explaination for the code cause am still a begginer on the asp
i want to know that is it possible to copy from a word document and paste it on to a textarea on a asp page. when i do it normally bullets are not paste as it is . it is changed into different symbol( inverted ?).
I am writing a web app that will copy large files (250-3,000 MB) and wanted to know the easiest way to implement some sort of progress bar? Each copy will only have one file, but I would like a way for the user to see how far the copy is.
I need to disable the right click "copy" option on an ASP page and add a Copy button that will do the same thing.I was able to disable the Copy when a user right clicks, but I need help copying the image to the clipboard when they click a button.
i need to copy all data from a database to another database, can anyone give me an idea how to do it?? besides that after i copy all the data i need to clear all the data in the old database
I need to deploy large numbers of small files via as ASP script. A task that takes an app likc XCOPY or whatever underpins NT a matter of seconds, takes the FSO .Copy action ages to complete. It's almost like FSO uses the old DOS COPY on a file-by-file basis, it takes so long.
Needless to say, this often ends in a script time-out for larger operations.
Anyone know of an easier/better way to do this? Perhaps .Net (with which I'm not yet massively familiar) offers a better copy object? Failing that, perhaps there's a server component someone could recommend that handles copying of large numbers of files better than the native FSO?
I have a locally hosted (via an executable) asp application. Does anyone know what would be the best (cheapest) way to add copy protection in it?
The application is an exe web server with the asp pages embedded in the executable. No one can copy the asp pages, but they can copy the executable and distribute it that way. I don't want them to do that.
If there is some sort of wrapper or asp code I could add to it for licensing or registration, please let me know.
i want to know that is it possible to copy from a word document and paste it on to a textarea on a asp page.when i do it normally bullets are not paste as it is .it is changed into different symbol( inverted ?). how can i overcome this problem.
I am currently accessing information in an access database using ASP and displaying it on some WebPages (both the access database and the website are on a standalone machine). I have a problem that the website needs to be moved onto another standalone machine and the database is not on it.
However I plan to run ASP and HTML to create the WebPages and then make a copy of the WebPages and then move the copys across? This machine will not have the database but because it has already retrieved the information (from the first time using ASP) it does not need the database. Is this true?
i want to copy a FILE from some SPECIFIC URL to my server through my ASP code....can any1 help me in this regard ..i ve no idea doing this. FILESYSTEM OBJECT just support the physical files.
help me make a secure web page that does not allow users to copy the address and paset it back into the address bar . and also if someone can help me make a sign up page and a database where users can sign up and login all in .asp .
I m in the completion of a "backup script" from remote to local folder. However, i m using the fsobject to make this copy. Of course, when i run this on my local intranet, it s so quick that i don t have the time to realise what s going on and it s already copied on my local folder.
BUT, if i run the script on the Internet (since the file is something like 5Mb and up) i don t have any indication that the file has been copied on my local hard drive. Is there a way that i could display some "waiting signs" (ierogress bar or else) while the copy takes place ?
I can't find any documentation on an array.copy function for asp!!! I am sure there is one but can't remember how to use it. Anyone have a link or a quick example?
I must have about 300 images I intend to manually type into a database. Aaaaargh! I was hoping someone might be able to give me a script that if I were to place all the files on a server, I could access the directory, and loop through each of the files, storing the name in a field... Can it be done?
I have a form that has a place for "Customer" and "CO-Customer" information. I want to put a button by the CO-Customer section that will copy the Address information from the Customer. Do I have that button be a Submit button that posts the information back to the form and the writes it?
I need to copy tables from 1 database to another database. My problem is that the database which I'm going to copy data to, is created instantly then tables are copied to it. I'm not sure whether this can be done.
I am trying to use the FileSystemObject to create a copy of a directory (including all sub-folders and files within this directory) but i just cant get me head around it.
Can anyone point me to a tutorial or some sourcecode that i can play with?
I can log into the server, run the asp page and make the following test code work, but if I log onto a workstation and run the same asp page, I don't get an error, but the file copy doesn't work. I have anonymous turned off because I record LOGON_USER as the clerk in the site when the user processes orders. Why would this work running directly from the server but not from a workstation? Code:
When the user fills out the form, I want them to enter an email address via the form, such as the email of a supervisor, and carbon copy the form to them.
I have a need to have a web server (windows based) grab files each week from a linux based server - hosted elsewhere. I cannot use UNC paths.
I want to have a script (.asp/asp.net) on the windows server that I would provide a list of files to copy. The script would then copy the listed files.
The problem is that the using a filestream and copyto runs into an error with URI paths.
This will be a substantial amount of data each week. I don't want to copy it locally and then back up to the windows web server. I want/need the copy to be directly between the two servers.
I am trying to create a blank table based on an existing table. I have tried using CREATE TABLE but unfortunately it doesn't appear to be flexible enough in that it didn't allow me to set some of the field properties such as input mask on a date field. Now if I can dynamically copy a table that will solve my problem.