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
The problem concerns 2 tables, cart_products and cart_shoppingcart.
Cart_products contains all the product data (eg, prices, product's key name, etc), but most importantly, it contains the quantity of stock (prod_quantity) for each item.
cart_shoppingcart contains all of the user's items in their shoppingcart, including those that are part of an (customer) order; these have the order_number to differentiate from those that aren't in any order (their Order_number is 'no_order', the others have the order number).
Now, what I want to do is this:
For every item in the order (ie, every entry in cart_shoppingcart that matches the username and order number), take the quantity (x) the customer is ordering, then take the quantity of stock remaining (y), then subtract x from y to create the new stock level (z) and update the appropriate record in cart_products with z (all this with SQl preferably).
I was thinking of using a Do while loop, but realised that it wouldn't work as I'd have to use several SQL statements and then I'd run into a problem the minute ASP reads "objrec.movenext".
I'm trying to pull the last 5 records from my database.
<% j=5
rs.MoveLast
While ((j>0) AND (NOT rs_article.BOF))%>
''Execute HTML and data insertion here
<%rs_article.MovePrevious
j=j-1
Wend%>
Everytime I attempt to run this code, I recieve an HTTP 500- Internal Server Error. It tells me no more than that. I know that my connection settings are OK because when I move forward through the database (first five records), the code executes without error. And yes, my Cursor type is Dynamic.
Alternatively, I would also like to know how to add new recordset to the beginning of a database rather than the end.
i have 3 table.
table 1
table 2
table 3
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:
Is there a way to copy the current URL address into the a variable?
Like I want:
*h_t_t_p:///thecurenturl.myurl.com
I posted it this way because new users can't post urls:
dim currentURL='the current url
Is there a way to do this?
is there a vb function that I can use to copy chars 1, 3, 5, and 7 from a string of 7 chars?
View Replies View RelatedI 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?
View Replies View Relatedi 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
View Replies View Relatedis 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??
View Replies View RelatedAnyone 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.
I am using asp (vbscript) with an Access 2000 DB
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 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.
View Replies View Relatedi 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
View Replies View RelatedI 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.
View Replies View RelatedHow do I copy a mysql DB table in ASP?How about renaming a table?Is there a way to retrieve the names of all the tables in a mysql DB?
View Replies View RelatedI 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.
View Replies View Relatedhelp 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 .
View Replies View RelatedI 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 ?
srcfile = (Server.Mappath("../db/db.mdb"))
desfile = "c:01db.mdb"
fso.CopyFile srcfile,desfile,true
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?
View Replies View RelatedI 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?
View Replies View Relatedi hv 2 tables log and log2 having same columns of same data type. if i want to insert all the data from log to table log2. how to do it.
View Replies View RelatedI 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.
View Replies View RelatedI have an Access database with two fields that I would like to group by. The two fields are location and department. Field names are "Location" and "DeptName".
I have the code correct for grouping by location. That code looks like this: Code:
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: