Modify A Field Using Pure Sql
I have a program that will need to update a certain table entry repeatedly - so I want the transaction to take place without using up too much time or system resources. I basically want to update the field with the current time i.e. Now(). Let’s assume:
The table is called tblExample. The field is called LastTime.
I could do this very easily using record sets, but I understand that using pure SQL is much faster than using record sets. So, how would I update the field using only SQL?
View Replies
ADVERTISEMENT
I came across this article titled Pure ASP File Upload at http://www.asp101.com/articles/jacob/scriptupload.asp & tried it on my local IIS5.1. Intranet server & it worked. I saved the necessary data in a MS-Access database file (& not in the hard disk).
How do I mail the uploaded file as an attachment using CDO.MESSAGE? I tried getting in touch with Jacob, author of the article at the above URL, by e-mailing him at his e-mail id (which is given in the article) but unfortunately, the mail bounced back saying delivery failed! .
View Replies
View Related
How do I change the text between a carriage return and a colon ":" in a variable?
I am calling a memo field in a recordset and want to change the format of text (colour) between these two points. How can I do it?
View Replies
View Related
I want to erase a line (or modify a number) in a text file throught asp, how do I do that? I have noticed that there are three ways of opening files,
1=ForReading - Open a file for reading. You cannot write to this file.
2=ForWriting - Open a file for writing. (If open an existing file, it deletes everything)
8=ForAppending - Open a file and write to the end of the file.
How can I just skip a few lines and erase a destinated line or maybe change a word in a line. without using an brute force (copy the file back and forth...)?
View Replies
View Related
I've built an array like this and I've put it into an application:
Code:
If not isArray(Application("utenti"))thenDim online(1,4)online(0,0)=4 online(1,0)=1online(0,1)=5online(1,1)=1online(0,2)=7online(1,2)=1online(0,3)=9 online(1,3)=3online(0,4)=15online(1,4)=3application("utenti")=onlineEnd if
Now is it possible to modify some values in this application-array?For example trying to set the value in position 1,1 equal to 3 I wrote: application("utenti")(1,1)=3
or
Redim Preserve application("utenti")(1,1)
application("utenti")(1,1)=3
View Replies
View Related
I've developed a web app that generates documents (like word files, opendocument, excel etc) let's the user download it to their computer, edit it, and then upload the modified version, where it would be stored in a database.
I'm trying to find a way to let the user edit the file on-the-fly, and when saving it automatically update the database. That is, I'm looking for a way to automate the download-open-edit-save-upload cycle. Ideally, when clicking on a link, the user would choose to open the file with the apropiate application, and when saving it the database would be updated. So, any ideas?
View Replies
View Related
Does anyone know if there is a way of changing IIS settings using ASP specifically:
"The content where this content should come from" radio button property set on the Virtual Directory Tab (of a VD).
View Replies
View Related
I have been using pure asp upload for uploading pictures and files fo rome time now.
I have a question about it thou - Is there any chance that the pure asp upload can upload a file to a directory and then copy it to a backup directory?
If anyone ever come accross this issue please let me know how u resolve it.
View Replies
View Related
I managed to find the problem with my script thanks to jmurray's help. However I am now left with a confusing puzzle and I cannot any information about a workaround.
The error I now get is:
Cannot modify or delete an object that was added using the COM+ Admin SDK
I know now the reason for this is because I changed the 'from' email address in my script. If I put it as 'service@safetouch.com' it works fine. If I change the address to ANYTHING else, I get the above error. Is this something that can be corrected through scripting? If not, any ideas where I should be looking?
View Replies
View Related
I have a databse in MS Excel which I would like to use it in ASP? I got instruction on how to open and display the Excel databes in ASP, but I cannot make it to modify/add/delete the records.
View Replies
View Related
any way to modify text content of a word document through ASP?
View Replies
View Related
I'm looking for a code already written if it is possible (as i need to do this soon)I have a database(access) and the users submit data from a asp page and it stores the values. Then it also allows the users to login to the web page using the data (username and password) inserted by the user.
What i want is that when the user logins, to be able to modify the inserted data..Perhaps the user wants to change the e-mail address. I tried doing some search in google but the results were no good.
View Replies
View Related
I would like to modify IE page setup before printing the window. But i want to do it without opening the FILE-> Page Setup window. In fact, i would like to remove the header and footer of pages beforeprinting them. but i want to do it using asp or vbscript and without any end user action.
View Replies
View Related
From the ASP application I am trying to 1) open a template 2) add data to a couple of fields (passed from order.asp to invoice.asp) 3) do a Save As so that the user can save to client.
I have this code working fine for a word document, but I am having touble with the XLT. Any suggestions?
View Replies
View Related
I created an asp page it looks different when looked from an 1024x768 than it looked on 800x600 resolution. how to control this?
View Replies
View Related
I've got quite 20 identical MDB files running on an IIS5 server. From time to time I need to go into various tables and add a field or two. It would be great if there were an application out there that could either: sync all MDB designs (and/or data) esignated to match one I've added some fields/tables to OR go into all designated MDBs and create new field(s) or table(s).
I've began writing something like this that right now just does part of (b) but I'd rather find something that is much more slick and complete.
View Replies
View Related
I manage to solve the last problem, but now I've encountered another one. I think there is something wrong with the UPDATE statement in this code. I am using Oracle 8i and Sun One ASP. Code:
View Replies
View Related
I have an Excel Template that is filled out in certain senarios. What I want to be able to do is access this existing Excel Template through a webpage, enter nessisary data into the template, and then e-mail these changes to certain people. The original Excel template needs to stay Unfilled out and unmodified once the process is complete. If saving a different copy to e-mail is nessisary that is ok. I have Created the Excel object on the server to be filled with database info from a query, but I'm not sure how to open an current excel document and then email that document onces it is filled out..
View Replies
View Related
I need to alter a dremweaver Update Record function but am a bit lost with it. I basically need to take the values from 3 drop downs that let you selct the date (day, month year). I've written a variavble that adds these together to make a date:
JJ_theDate = Request.Form(selectDay) & "-" & Request.Form(selectMonth) & "-" & Request.Form(selectYear)
but have no idea how/where to slot this in with Dreamwevers code (below) that does the SQL update.. Code:
View Replies
View Related
If anyone can guide me to change my basic data results link bar buttons (First, Next, Previous Last). I will like to use my custom arrow buttons but don't know how. The default buttons are generated by default with i create a query. Where do i go to modify these buttons, and what code do i use in the new buttons i will like to use....
View Replies
View Related
I am using a Relational database for my site and i have the following tables:
FIXTURES, GAMEDATES
the fields in FIXTURES are:
GameDate
Home
Away
(All of the above are numerical fields)
the fields in GAMEDATES are:
DateID(integer)
GameDate(#Date Field#)
What i have done is in the GAMEDATE field in the FIXTURES table i have used the ID number of the date that i wish to assign to that record - using a LEFT JOIN to display the actual date that is pulled from the GAMEDATES table (That which corresponds to the relevant id used in Fixtures)
The problem is that in some of my code i want to display records using sql and sometimes in the where clause i use the following:
WHERE Fixtures.GameDate<=(Date())
obviously meaning WHERE GAMEDATE is LESS THAN or EQUAL to TODAY.
The thing is when i use the join it does not use the where clause and displays all of the records in the FIXTURES table.
Does any one know how to get around this, i have not received any error messages it just isnt displaying the right data
View Replies
View Related
Im comparing values in a field while doing a loop if sAct<>myData(5,i) then At the end of the loop I make the value of sAct equal the current myData
This will work when comparing other fields withing my recordset (so I know the statement works) but it will not work for the field I want to compare. The only difference with this field is that it has null values. Could this be the problem? if so, how do I deal with nulls?
View Replies
View Related
I have a input form with 5 fields. One of the fields is MajorNo and the other is named Description.
I have a reference table in my MS Access database (tblMajor)that lists the major numbers and their descriptions.
I would like to have the description field in my ASP automatically filled based on the major number entered on the form, so the user will only need to input the major number when submitting to the Access table (tblSalesTotal).
View Replies
View Related
I am trying to pass a hidden field value on a form into another field on the
form so that it can then be inserted in the database, to enable me then to
reference that number at a later date.
(The hidden value (1 for example) would then automatically get passed to the
other input field.)
The code for the text field that allows users to type an number into it for
submission to the db is below, but what code do i need within the hidden
field to populate this text field below so that users do not have to type the
number in? Code:
View Replies
View Related
I have being working with making an edit field over the past few days. The edit function is now working fine. The edit fields that i have are for id, subject, notes, timedate.
All of the edit screens are one line text screens. What I want to do now is increase the size of the notes box to a larger textarea type box to make it easier to edit notes. The notes field in the db is a textarea field. Code:
View Replies
View Related
When you select the "Country" field in a Hotmail "get new account" link, the field "State" changes automatically, giving you the correct States that belongs to the chosen Country.
View Replies
View Related
I want to know what's the differences between
Request.Form("Field Name") and
Request.QueryString("Field Name")
OR they function exactly the same, which is to return the value of the
field??
View Replies
View Related
I would like to capture an entered value and use it in a query (Access)
Part No. __________
Do I need to store it in a variable and then can I have the query come up on the same page - they would enter a value and click a submit button. I'm not sure that I am on the right path. I'm not sure what syntax to use. Code:
View Replies
View Related
What is the correct code to use to hide a section if a specific DB field is
NULL.
View Replies
View Related
I'm trying to select all records that are true.
Code:
activerecord = -1
strsql = "select cnum from [topline data] where cnum = '" & cnum & "' and activerecord = '"& activerecord & "'"
is that right?i get this error when it equals 0. Microsoft OLE DB Provider for SQL Server error '80040e07'
View Replies
View Related
Using asp and mysql, can a text field in the db have a record with asp code in it and then display correctly on an asp page?
My experience is that it does not show anything in the <% %> tags but it shows the asp code when you view source. My coworker wants to make our website database driven and this text field was going to be the page content with html and <% if then else %> statements.
This does not work with php either so is there another field type that will parse server side scripting?
View Replies
View Related
In our ticketing system database, some fields may possible contain XML. To display a field for example, I have always used: Code:
<%=(rs_tkts.Fields.Item("CloseDesc").Value)%>
but this does not display the xml code listed. what I should do?
View Replies
View Related
Im wondering if there is any way to add a field into an MS access Table using SQL/ASP..
The reason im asking is my database online is Access 2000 (which i have at home), and im in work and they use Access 97.. so i cant download the database, add an extra field into the table, and then re-upload..
Ive tried using a Make Table, Update, Append.. but it doesnt like any of them statements..
View Replies
View Related