Using a query statement, I am trying to add values into the textbox of an ASP page to enable users to edit it. But it only displays the first word of the record. The rest of it gets chopped off. Code:
<P>Company Name:<INPUT NAME ="CompanyName" style="WIDTH: 371px; HEIGHT: 22px" size=47 Value=<%=objRec.Fields("company_name")%>></P>
The value in the textbox only shows R1 when the value in the SQL database is R1 International Pte Ltd. The datatype in SQL is char if it makes any diff.
I want to call a recordset so you can edit the details and then obviously pass the parameters onwards into the db. However, the user guide just says this:
To process other fields in the form, use the Form collection of the upload object the same way you would use the Form collection of the Request object. For example, if your form had a text element named UserName, your processing code would include: Code:
I have a main data entry form which has a link to a detailed data entry form. The value of the link in the main form is the sum total of all the line items in the detailed form. The detailed form has fields to capture the individual line items like contracted service expense, travel expense etc. I am capturing the total of individual line items using session variables so that when the values of the main form is saved these total of line item values get saved. However, if one gets to the mainform via login and tries to resave the values (which is already saved), the above session variables (from the detailed form that contains the sum of line items) get null values. However, just navigating to the detailed form through the link and coming back to the main form sets the value in the session variables.My question is how to get the session variable values without having to go to the detailed form and come back to the main
if it is possable in ASP i could store a value in one ASP page and look at it on anouther ASP page. for example:
On a login page i want that page to store a value called rights that is a number. when it goes to any of the other pages EG add user, Delete users if the user does not have the needed rights to takes it back to the main screen.
I wish to get and set values on child controls on a formview.For example. Changing the text in textbox. Hiding or unhiding child controls based on user. Replacing a blank with a default or calculated value that will need to be generated at runtime.It seems as though this should be thoroughly documented, but I'm not finding much.
i need to know if i have a loop that outputs values for each month how do i get it to add the values and only display them every 3 months,(every quarter)?
jan 123 feb 234 mar 432 first Q 789<---------how do i do this? Apr 125 may 548 jun 323 second Q So on..
I need to use the value=rs("image") in a javascript function, but i need the selected value of rs("iname") in an ASP array. Request.form("dd1") will always give me the value of rs("image"). Is there any way around this?
I am facing with a problem of getting Drop Down Values. How do I get Drop Down Values in a array.e.g,
On Submit, I hv to display records based on similar MergeIDs, Like, e.g for MergeID - 1001 i have 2 records in database So I will hv to display those two rows in a concatened form. But these two records hv different IDs.
ASP Display DropDown MergeID Username Task ID 3 1001 Ashish,Kamal Design,Test 21,22 5 1002 Sunil,Anil Data,Design 25,26
Now, when I Select 3 and 5 in drop down,I want that for MergeID it should show DD value as 3 and for MergeID 1002 as 5.I am not getting that.I am able to get IDs 21,22 in an array.
Dim ix For ix = 1 to Request.Form.Count fieldName = Request.Form.Key(ix) fieldValue = Request.Form.Item(ix) Response.Write fieldName Response.Write fieldValue & Next Response.End
It is not returning the results of any field on the previous form page. Does anyone know what I might look for?
I'm a (moderate) newbie to and I'm building an ASP/VB db-driven site where the user selects a brand from a menu, this determines the contents for another menu with models. Selecting a model displays details about that model. Nothing too original here Its a small low traffic site with no ecommerce elements - just window shopping.
My questions is : I need to know on all pages what the current brand and model are (and modify these when the user changes them).
From what I understand there are 3 (?) methods: server vars, session vars or hidden fields. Which should I use for this purpose and can anyone point me to some good related examples/tutorials? (I've read the stuff on this site of course).
I have a form which the user fills and submits.i have insert statement there. When i submit the form to itself ,the values get submitted and inserted in DB easily.
How is it possible to execute an exe from asp and get a returned string (no http headers in exe) ?
To run exe I use : <% cmdExe = sPath & "cgi-bin equest.exe" Set WshShell = Server.CreateObject("WScript.Shell") sResult = WshShell.Run(cmdExe, 1, True) Set WshShell = Nothing
Response.write sResult %>
sResult always content "0" and not the string returned by exe file (something like "!!-1!blabla!blablablabla!")
- How is it possible to get the exe returned value ? - Is there a solution with asp.net ?
I'm trying to determine if I can use transactions in my ASP applciation against one of our Oracle 9i databases. My WROX manual says I can do this if the Transaction DDL property of my connection object is equal to 8. I've checked my connection properties with the following script and determined that my Transaction DDL property is 2
'============================================ Set conn = Server.CreateObject("ADODB.Connection" conn.open Session("PROVIDER")
For Each Item In Conn.Propertie response.write Item.Name & " = " & Item & "<br> Nex '============================================
But what is 2? MSDN (http://msdn.microsoft.com/library/d...oprg04_83jt.asp) says there are a number of possible vaues for Transaction DDL such as
I have a submit form that collects my values, and if my form action is "mailto" the values are passed, but if I try to pass to another asp page the values aren't sent and the asp doesn't execute.
I've created a web form with multiple textfields for acquiring somes date of birth (i.e. textbox for DD, textbox for MM, textbox for YYYY), now what I'm trying to do is grab the values from these objects and combine into 1 session variable, which later on is inserted into an ACCESS database.How do I append these values together to be one value in a session variable (i.e 23122004). I have a input mask inside the ACCESS database, so it needs to go in this format. I assume once I have captured these 3 fields, I need to convert them to integer, and then merge?
How to store form's textbox values in VBScript variables? I tried something similar likr this: Dim myVariable myVariable=Document.myFormname.myFieldName.Value
i want some help in how to retrieve values from multiple selection listbox. i want the values retrived to be used in the search which i perform from the database. i m doing a search feature which u all often see in job search sites. so someone selects multiple cities to search in i want that to include that in my search query.
I have a form that send values to a second page. i m trying to compare the values received from the form with other values retrieved from a database. so if a value already exists then an error message is displayed. in order to compare the values i need to print them on the second page but I m bit stuck with this. i used request.form("category") in order to retrieve the values from the form but it doesn t work.
I'm again having trouble putting ASP records INSIDE html link. Here's the string I put inside Access field:
No room number specified (<a href='contact.asp?subject=corrections/addition for AASG.info group ID <%=(Recordset1.Fields.Item('group_id').Value)%>'>update</a>)
but it is not working. The link created in my html output puts out asp part LITERALLY and does not put the VALUE of the recordset.
This didn't work either:
No room number specified (<a href="contact.asp?subject=corrections/addition for AASG.info group ID <%=(Recordset1.Fields.Item('group_id').Value)%>">update</a>
I am trying to retrieve values from a table in database and want to implemtent the following logic: if the entry contains a text with a given name, then change the bgcolor of the <td> in green, or if the text contains a different name for instance, sam, then change the color to pink.I have used the code below to generate this; however, it doesnt display them as expected. Any idea how to implement this logic? the code <%if (rsTypes("one") = "derek") OR (rsTypes("one") <> "derek") Then Response.write "<td border = '5' bgcolor = green>" %> <%=rsTypes("one")%> <%End if%>
The problem i am having is adding 2 rs values to each other to come up with an amount.
so i have something like the following:
sql1 = "select sum(col1 + col2 + col3) as result1 from table where col4 = "y" " set RS1 = Conn.Execute(SQL1) pastdue1 = formatnumber(rs1("result2"))
sql2 = "select sum(col1 + col2 + col3) as result2 from table2 where col4 = "y" " set RS2 = Conn.Execute(SQL1) pastdue2 = formatnumber(rs2("result2"))
pastduefinal = (pastdue1 + pastdue2)
But when i do a response.write (pastduefinal) i get "0.000.00" Does anyone have any idea? I replaced the formatnumber with formatcurrency but still didnt work. Am I using the addition incorrect?
How do I pass in more that one variable in the form tag below code: <% Dim CmdPopulatelist Set Conn= Server.CreateObject ("ADODB.Connection") Set CmdPopulatelist = Server.CreateObject("ADODB.Recordset") %> . . <% sql_select= "select * from Patch_Feedback where Patch_name= '"& view_name &" ' and Name_of_user = '" &Name_of_user &"' " %> <% Conn.Open "DSN=Patch;uid=cmadmin;pwd=dci01;database=cm_db" Conn.execute(sql_select) CmdPopulatelist.Open sql_select, Conn %> . . . <form method ="post" action="updateresponseA1.asp?update_ID=<%Response.Write(""& CmdPopulatelist ("Patch_ID") )%> ">
