How do people go about batch updates. I can do batch deletes no prob.
In ref to bacth updates such as One to Many.
Lets say i want to move everyone from one group to another
thats where i'm stuck.
Tbl1 : Category
Tbl2 : Users
If for instance i need to change 45 (id=25) users from
Tbl1.field3 to Tbl1.field3 to (id=18)
In Tbl2
Okay there is an unique EventRegID for every registration. When people first register they get pre-registered. Then an admin comes in and confirms or wait list them (based on whatever requirements). My question is how can I tie the EventRegID to a form with multipule ID's so they can batch confirm or wait list the PreReg list? Code:
View Replies View RelatedWe have LOADS of documents scanned to PDF format, stored
in SQL tables.Allowing a client to browse our ASP driven site to select
and view individual PDFs has been no problem. ("index"
table is queried to show list of available PDFs, user
clicks a link in the list, PDF reader shows the document
in a new window.)
Now, they would like a feature that would PRINT (at their
location) batches of documents via the website,
preferablely with a single click.
Security issues, warning messages, etc., aside,
what MIME-type combination do I need for and ASP to write a BAT file to the response stream?
e.g.
Response.Clear
Response.ContentType = "application/octet-stream"
Response.AddHeader "Content-Disposition", "attachment;filename=message.bat"
Response.Write("net send COMPUTER2 success")
Response.End()
This code does not work!
Which is surprising because in my current config, the following html works fine, and executes on the shell:
<A href="message.bat">test</A>
First, a little background. I'm developing an order management system for my company and I want to be able to print a batch of packing slips in one go without pulling each one up on the screen and clicking 'Print'.
How can I do this in ASP? The only way I can come up with is to loop through the records and concatenate a string with the HTML code and then send that string to the printer. But, I'm not exactly sure that's the best way or if it is even possible.
I want to basically click a button that says "Print All Packing Slips" and never see an output screen.
i have to start a batch process from a dll to transfer
files created by this dll to remote ftp server. I created
a batch file:
ftp -n -v -i -s:D:atchftpcmds.txt ftp-server
and a file containing the ftp commands:
user username password
lcd D:atchmedia
mput *.*
quit
It works pefectly when i start it from the dosbox. But
when i call it from the vb dll implemented in IIS (shell
("D:atch ransfer.bat")), it does not complete the
transfer and hangs after 400-500 (small) files.
How do I statically change my ip address to specific IP via a DOS batch file and back to DHCP via another DOS batch file?
View Replies View RelatedI have a web page that sends emails to groups of recipients. It uses CDONTS to send each email. While it works fine for sending a small amount of emails out, it chokes the page when sending to large amount of email addresses. Basically, it loops through each email address and sets the CDONTS object each time. I need to do this because each email is personalized.
Does anyone have any thoughts around how to optimize this code. Is there anyway in ASP to send the code to a background process for example?
I need to send batch html emails out from a db mailing list (anything up to 1000 in one go).I am using CDOSYS and standard ASP. My problem is that it will error if I try to do any more that 5 every 30 seconds - this is fine when I send them out myself (I have a script to do this) but now I need a program which will allow users to send out batches and I want it to appear seamless.
View Replies View RelatedHow do I statically change my ip address to specific IP via a DOS batch file and back to DHCP via another DOS batch file?
View Replies View RelatedWe're trying to write an application that will allow a user to enter an id field from an ASP intranet page and when they hit the enter button, fire off a print job. The problem is, Adobe must be open as the items being printed are PDFs.
We tried firing off a print command using MS SQL cmdShell() (not sure if that is the exact name of the command) and it works, but it never completes. The process hangs in the database because, we think, it hasn't closed Adobe, therefore never coming back to the query. We wrote the query into an ASP page.
Adobe must be open or the documents won't print properly.
Does anyone have any suggestions to how we can automate this?
how to call a batch (.bat) file from an asp file
View Replies View RelatedI would like to send batch e-mail from fields in multiple records.
View Replies View RelatedI have a form that users enter details of a car (e.g make model , idnumber#) and then press save to save to the database they may want to order 10 cars with the same details exept the idnumber so to save the users entering in all 5 details I want to make it easier.
Should I have a list box and let the user add idnumber items from a text box and then pass this to my update asp and loop through + to save to the database or should I
save one record and then return back to the same form Note : I am having problems with this method as only part of the fields show when I hit the back button I just wondered what is the best method of doing this I am spoilt for choice and I also get problems.
Was wondering if anyone had any suggestions on how to execute a local batch file by simply pressing a button on an ASP page?
View Replies View Relatedhow to run a local Batch file from an asp page by simply pressing a button on the page?
View Replies View RelatedI have a batch file that needs to execute every day and I need to run it in a silent/invisible mode. I looked up on the Internet and found this command: shell("batchfilename.bat").
Upon failure, learned that it is a Visual Basic command and not VBScript command. I wonder if anyone knows how to run a batch file using vbscript that runs in invisible mode?
if anyone has experience in building the ability to upload/insert multiple images from one directory on the client machine to an Access database via asp. The process would be to click on the browse button for the correct images and you would be able to click on multiple images using ctrl or shift button and then insert the selected files into the database. Can this be done?
View Replies View RelatedI'm trying to call a batch file that I've built using the FileSystemObject and CreateObject("Wscript.Shell"), oShell.Run. in an asp script. Naturally, I can get the script to work from a command line but not from abrowser. The page does not throw an error but the oShell.Run. portion of the script doesn't run.
View Replies View Relatedhow to go about sending a batch of sql statements from asp to sql server, and
having errors appropriately handled? for example,
i want to send the following stored procedure calls to sql server in a
single batch from my asp code, rather than using a loop in asp to execute
each procedure individiually. if one of these fails, they all should fail.
exec myProc @param1 = 'A'
exec myProc @param1 = 'B'
exec myProc @param1 = 'C'
exec myProc @param1 = 'D'
exec myProc @param1 = 'E'
exec myProc @param1 = 'F'
im trying to run a bat file on windows server 2003 and am running into nothing but problems.
i have IIS on my XP workstation that accesses the 2003 server. what im about to explain below works properly on the XP IIs.
i have two files: somefile.asp and somefile.bat. the asp file creates a wscript.shell and then tries to execute the run method for somefile.bat.
however, it isnt working. after an unexaggerated 7 hours of searching google/etc, i have found nothing but frustration and deep, seething anger regarding this problem. Code:
i used following code:
<%
set wshell = server.createobject("WScript.shell")
wshell.run "E:aaa.bat"
set wshell = nothing
response.write("worked")
%>
It does not show any error message and gives the output "worked"
I have installed .dll files for wsscript
Is there any other way to call batch file from aan asp page .
I have a batch file that takes variables from the cmd and passes them by sqlcmd to an SQL script. When I pass the variable 'MikeTestList' the script runs as expected with no problems. When I passed 'BulkTransferTest' I got an error message, 'The string or binary data will be truncated'.
Some testing has shown that I get the error when the string is anything above 12 characters. Is there a limit to the length of a string you can pass using sqlcmd from a batch file? Is there any way around it?
Also, if I have a space in the string, it only passes the string up to the space. I have tried to fill it with a '%' which then gets passed as is, so the % stays in place through out the script. Code:
here is the scenerio
in master batch table i have various master batch like
200701-0001
200701-0002
200701-0003
Now each master batch can have multiple final mixed batch like
200701-0001-01
200701-0001-02
200701-0001-03
and this record is inserted in to fmix table.
so i have a form in which i have a dropdown menu in which all the master batch is listed,
i select 200701-0001 and that value is passed to next page where i will enter other fields data and insertion to my fmix_no will be done automatic like 200701-0001-01, 200701-0001-02 and so on,
how to achieve this
so in short each master batch will have more than one final mixed batch.
pls help, also if u have any online contact in yahoo or msn pls send me, i am so confused and badly struck deadline is just couple of hours away. my yahoo id is(E-Mail address blocked: See forum rules) you can PM me i am online right now.
I have this page that displays a dollor amount code:
<td class="tableValue" width="122">Expiring Premium:</td>
<td width="400" align="left">
<input name="Expiring_Premium" type="text" value="<%=formatcurrency(Expiring_Premium,2)%>" class="tableValue" size="27"></td>
it would display $100.00 when i go to insert that value into the database the value i get is $100.00 and i get an error, i need to get rid of the $ sign but not sure how to do it because the number range can be from 1 to a billion dollars.
I have this code for asp that if the value is null it insert a null instead of a blank, else i get an error message in access.
'Expiring_Premium = request.form("Expiring_Premium")
if (request.form("Expiring_Premium")) ="" then Expiring_Premium = "Null" else _
Expiring_Premium = request.form("Expiring_Premium")
Any ideas on how i can strip off the $
I'm looking to update a column in a datebase that has null values with N/A and I'm using this:
UPDATE tbl_members
SET branch_no = 'N/A'
WHERE branch_no = NULL
The only reason I'm trying to do this, is because I can't seem to do if statement on a null value.
This is hard to explain, but I have wanted to know how to do this. Say you have a website, and you have a news box(where you can report all of your news), made of a picture(s), you know like something that says "news" at the top of the 'box', and the sides of the 'box' are a picture. I have wanted to know how to make one of these 'boxes' without having to use the <div> tag, and type as much text in there as i want, and it wouldnt mess up a table or anything, or realign it, because the <div> automatically wraps around the text, fitting perfectly to it. I was wondering if you can 'wrap' around the text without a <div>, but with pictures. Here is an example, this picture called ex.gif.
I know it is a link menu, but what if you wanted to add a couple more links. How would you get the 'box' to automatically resize so that it does not messup the table. I am not even sure if this is capable in ASP, but I am sure somebody knows what I am talking about.
I have a guestbook form that inserts the fields into an
Access Database. The database is residing in the "fpdb"
folder that was created by FrontPage. The ASP page that
writes the data into the databse uses the
"recordset.addnew" method. The code was working fine a
couple of weeks ago, and now all of a sudden the error
message "Cannot update.Database or object is read-only"
pops up. The ASP code or the database was not changed or
modified in any way, neither were the permissions for the
account.
I have quite strange problem and hope you guys can help me out or provide me with some tips.
when using a update script:
UPDATE categorys SET main_cat_default= '0', banner= '', b_link= '', external_text= 'Nākotnes parks', name = 'Arzemju muzika' WHERE (id = 115)
Then it messes up field EXTERNAL_TEXT. Instead of Nākotnes parks it saves it as Nakotnes parks.
But! when I open Enterprise manager and type in Nākotnes parks manually then it saves it correctly. So I believe there is something with update command or smthing like that.I changed collation also to Latvian and this did not work.
For laptop users who have an ASP application running on their laptops
- is there a way I can have it check when connected to the network
(via the FSO lastmodifieddate) which files need to be updated
(enhancements, etc.), then shoot the ASP pages that have changed down
to the client?
I'm using the following code:
rs.addnew
rs("application")=body
rs.update
body is containing a lot of text with vbcrlf in it.This is basically a form that is emailed and I want to save it to a db just in case the emails don't go through.
For some reason the field in the db (access) is only containg the first line until the first vbcrlf
I am updating some pages "font "style color size" and a few words in several of my asp pages. Most of them will update but I have a few that refuse to even after rebooting the server and clearing the cache on my current computer.
View Replies View RelatedI was able to generate an RSS for the news I provide with ASP and MS SQL backend. When I opens it its working fine with any RSS reader, But its not getting updated, when I update the feed. Its showing the one which I made the day one, How to rectify and what could be the problem.
View Replies View Related