I'm looking for a few methods for displaying contents of a recordSet, displaying the recordset in a table format, allowing the user to update the information they want to modify, then saving that info back to the database. I know of a couple of ways of doing this:
Create an html table dynamically from the recordset, assign the values html ids, write the info back to the recordset on form post and update the db. OK, that's the only way I know.
i am trying top update a field in my sql database but it wont let me??? does anyone know if my syntax is correct?? I have a field called userId in the database and want to replace it with my form request. Code:
View Replies View RelatedThe Folowing code is not working anymore.(500 error)
Set objRS = strSQL1.Execute
strSQL1 = "SELECT * FROM BannerRotor where BannerID=" & cstr(BannerID)
objRS.Open strSQL1, objConn , 2 , 3 , adCmdText
If not (objRS.BOF and objRS.EOF) Then
[ objRS.Fields("Exposures").Value =objRS.Fields("Exposures").Value + 1
objRS.update
End If
objRS.Close
The .execute Method works fine
strSQL1 = "UPDATE BannerRotor SET Exposures=Exposures+1 WHERE BannerID=" & cstr(BannerID)
objConn.Execute strSQL1
W2003 + IIS6.0
I use the following to update:
Dim rsEdit1
Set rsEdit1 = Server.CreateObject("ADODB.Recordset")
rsEdit1.ActiveConnection = MM_shop_STRING
rsEdit1.Source = "SELECT * FROM products WHERE pautoid = 12"
rsEdit1.CursorType = 2
rsEdit1.LockType = 3
rsEdit1.Open()
rsEdit1.("authorMemo") = "TEST" *Error message from this line
rsEdit1.update
rsEdit1.Close()
Set rsEdit1 = Nothing
The problem is that I keep getting the following error message :
"Microsoft VBScript compilation (0x800A03F2) Expected identifier"
I have been given the task to create a search page to search on of the tables in the sql database. I have been asked that the user should be able to search any field(which I
have done) but he should also be able to customise the form to display or hide any feilds in the results.
My table has about 20 feilds and different users wanting to you the search page will like to see different set of fields.
Is it possible using ASP to update the page display by selecting a record from a <select> box, then, search the db for the record selected and update the same page with the content of that record? Code:
View Replies View RelatedOkay 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 RelatedI have downloaded the DiscIDCalc program from CDDB. I've used it a lot because I've written my own application for my CD collections (keeping track of the track information of each CD, track duration etc). I've already got all my CDs into the application, I'm now just going through each of the disc again just to add in the DiscID information. I do it by running the DiscIDCalc program, generating the DiscID, and then then copying and pasting this DiscID into my application and then save it.
if anyone has successfully generated the DiscID within an asp page?
Now I have to have my browser up and this DiscIDCalc program up. Just want to know if there's a way to incorporate the two together (even if it means I'm not using the DiscIDCalc anymore.). This DiscIDCalc has a documentation for its DiscIDCalcDLL.dll but it's not something that I can CreateObject with, so I'm quite clueless... I don't want to use VB to write APIs for that
I use query string to search for records by using GET method. This method will generate querystring automatically by using the form name. Using search field together with drop down is fine but the problem is when i didn't enter any keyword or left the search field blank it won't display any result.
Unless I put "%" in the search field. How do I make the querystring change to "%" whenever the field is blank so that all records will be displayed.
I have the following piece of code:If RS.EOF or RS.BOF Then
Session("Authenticated") = False
Response.Write "Sorry, your userid or password did not match"
Response.Write "<BR>"
Response.Write " or you have not registerd yet, please register"
Response.Write <a href="default.asp">Clik here
Response.End
Here, I need to build the line (Response.Write <a href="default.asp">Clik
here)
dynamically, so that the html output from asp page
gives us <a href="default.asp">Clik here
i have a long recordset that i want to page through. can sql pass back say, 5 records from 20 to 25 out of 1000?
i can then pass 2 variables between the pages to dynamically generate the sql and thus page through the results. can someone post up a simple example of this if its possible?
With ASP is it possible to dynamically change the <title> tag depending on what record I am viewing? I know that you can do this isn ASP.net and PHP but was wandering if its possible in ASP too
View Replies View RelatedI am currently struggling with dynamically naming a zip file. Basically I want someone on my ASP site to be able to choose to download a zip file and the zip file to be renamed before it is sent to them with their login name. Does anyone know how I might accomplish this. Code:
View Replies View Relatedi have a form with two pull-down menus. when the user chooses a value from one, I need to go to the db and execute a query, and then populate the 2nd pull down menu with the retrieved values.how would I go about this? where do I add the listener function that will catch the selection event, and what should go in it?
View Replies View RelatedDoes anyone know if there are any IIS components out there that run on
IIS 5.0 that will convert LaTeX to PDF? I have written a script in ASP
that produces the LaTeX document, but am unsure of how to go about
converting it to PDF and delivering it to the client.
If you don't know of one, do you have any idea of how I might implement
such a transform? I would have to use a WshShell to run pdflatex on
the source twice before I could deliver the PDF to the user. However,
pdflatex outputs a PDF, so I would have to redirect the client to the
PDF, and then somehow come along later and clean it up. I'm not sure
if this would be the optimal process to take.
I have a form where there are 2 dropdowns. Based upon what you select in the 1st dropdown, that selection populates the 2nd dropdown. I want to change it so that if you select 'Loan Officer' in the first drop down, the 2nd dropdown turns in to a textbox, rather than the huge dropdown it becomes now
View Replies View Relatedthis form I need to create, I have very little experience in ASP. I will basically need to have a form that collects hours for a specific Week End Date.Also a running total for hours.
Dropdown with week end dates
Dropdown of Task, Mon, Tue, Wed, Thurs, Fri, Sat, Sun
Default 5 rows
Add Row Submit
Since I will need to dynamically add a row of data, I am not sure how to submit. What would you do in this scenario? Im so new to this and of course this is due ASAP.
I have an asp page in which if i click on add row i call a javascript function and create a new table row.This works well if i do not have to retrieve any dynamic data from my database. ie if i just have to insert for input type ="text" then no problem but when i have to do the same thing for a input type ="select" i have no idea what to do for the select has to retrieve records from the databse to allo the user to choose. How can i do this ?
my javascript function
function addrows()
{
var cellRight = row.insertCell(1);
var el = document.createElement('input');
el.setAttribute('type', 'text');
el.setAttribute('name', 'comment' + iteration);
cellRight.appendChild(el);
}
how can i adjust this to allow for select tag ?
Using preferably Asp or an Asp component, but maybe .NET, here is what I need to do:
A user enters a hex value (Or rgb if need be), which then colors a pixel high, n pixels wide gif and saves it to a folder in the sites directory.
Method Not Allowed
The requested method POST is not allowed for the URL /Database/processForm.asp.
Apache/1.3.33 Server at antonyx.freestarthost.com Port 80
i just got this error, however, i have managed to post data into my database on this server b4, why is this error comin up now, could there be a prob with my asp file??
When using ActiveX Combo Boxes, can you use the GetString method to populate the control? I currently am using AddItem, however, it is taking a long time to process. I know that GetString works well to improve the performance. Here is my code while using AddItem:
while not rsClient.EOF
Response.Write chr(9) & "MenuForm.lstClient.additem " & chr(34) & replace(rsClient.Fields("Client Name").value,chr(34),"'") & " [" & trim(rsClient.Fields("Client Number").Value) & "]" & chr(34) & chr(13)
rsClient.MoveNext
Now this is a weird one. I'm having a problem with a system in development. When I post data from a form in IE 5.01 it works fine, but in IE 5.5 it refuses to post the data to the server and in IE 6 it's scatty -- works sometimes but not others. Anyone seen this before?
Edit:
By the way -- this is normal VBS/ASP running on IIS 5 on an NT server
can values of variables be transfered through response.redirect onto the next page
View Replies View RelatedI have a form that ignores my form validation code. My code works if I use the post method of <%=Request.ServerVariables("SCRIPT_NAME")%>.
But, If I post the form to another .asp page, which I prefer, the code doesn't work. Do anyone have any suggestions? Here's my code.
I have a form that ignores my form validation code. My code works if I use the post method of <%=Request.ServerVariables("SCRIPT_NAME")%>. But, If I post the form to another .asp page, which I prefer, the code doesn't work. Do anyone have any suggestions? Code:
I have a service provider that's sends sms messages from clients mobile
phones to my asp page, problem is I don't know how to show the data and they
are not being helpful.
The process is simple as outlined below (instructions from service provider
Example: If you provide this: http://www.yourdomain.com/sms/sms.asp then we
will do a post via a standard HTTP GET as follow:
http://www.yourdomain.com/sms/sms.a...ISO-8859-1&udh=
How do I receive the url with the parameters in the address bar?
I would like to know which method is best in ASP when using/coding for email via a form.
View Replies View RelatedWhat's the best method to hide, or not show a certain record when doing a pull from a database, as in I am pulling a list with a dozen category's and I don't what to show one of them.
View Replies View RelatedI have a demo.asp page, that can't pass hidden value "mr progrramer" to
itself using POST method. Only "mr" is passed.
I created a second asp file demo1.asp and passed "mr programmer" and whole
string (include space b/w mr and programmer was passed successfully).
The code for demo.asp is:
<%
name = request.Form("name")
response.Write "hello " & request.Form("name")
' if name is empty then store some string with space in it
' problem is the word before space 'mr' is passed, but 'programer' is not
passed
if len(name)=0 then
name = "mr programmer"
end if
%>
Code:
I have a .asp page that uses the post method and it works fine on my computer using iis. But when i put it on the web server (it has windows NT4) it wont work.
I've read that you have to do something to allow the post method on the server.
i know nothing about windows NT4 but can get access to the server. can someone please let me know what i have to do to get this to work?
Just to let you know the post method is for ssending a login and pass to another page that search a database for the record. If there is another way to do this that does not show the variables in the url please let me know. i am also willing to make it so that everything is on the same page so i dont have to pass anything.
Based on what the user selects in a combo box I need to find the value from another column in the same record. This is what I am using:
rsPrice.movefirst
rsPrice.Find "Component='Desktop'"
If (rstPrice.BOF = True) or (rstPrice.EOF = True) Then
response.write("The Price for the Component Not Found")
else
curPrice =rsPrice("Score")
End If
I keep getting an error messages:
Microsoft OLE DB Provider for SQL Server (0x80040E29) Rowset does not support scrolling backward.
I'm looking for a renaming method for folder objects.I have an ASP (JScript) application that I'm creating that acts as a document library. Users can upload files, create folders, etc.
Most places I go to basically have: copy, delete, move, create textfile as the only methods for the folder object - NOTHING about renaming.
i have a search page script which consists of a text field and a pulldown menu. the search function using search text works but not the pulldown menu. do I have to set separate recordset for each of the search functions, one for the search using text field and another using pulldown menu?
View Replies View Relatedcan i gain the two result. in an asp page which using a stored procedure with execute method.
i want to execute the query and return the count value the query at the same time. is it possible and how?must i use ado? it is not possible to make it with execute method in asp.