code:
public function fncGetPageContent(intSectionId_In)
set rsPageContent = connection.execute("SELECT TOP 1 * FROM sections WHERE section_id = " & intSectionId_In & ";")
if not rsPageContent.eof then
strSectionCopy = rsPageContent("section_copy")
strSectionTitle = rsPageContent("section_title")
end if
rsPageContent.close
set rsPageContent = nothing
end function
My question is, how do I call this function and return the two distinct values?
Is there an elegant way that I can return a value from a JavaScript function to ASP.NET? I want to have a popup confirmation dialog using JavaScript and only have a button control execute its ASP code if the confirmation is positive. I can associate the JavaScript with the button using the Attributes property and get the confirmation dialog to appear but the button control always executes.
I have a problem with returning a value from an external function.....
My asp page is basically a list taken from a database. A date record is written from the DB, then all the recordslinked to that date are listed, then the next date, then the next series of records, i.e. Code:
I have a request form that is used for requesting copies og an edition of a magazine. What I need to do is get back the information, from a MS Access table, for the issuedate and deadline.
Because the deadline is not always the same number of days (ie dependant on issue it could be 14 days before, or 21 days before etc), so as well as picking the issue date from the table, I need to be able to get the deadline date back, and write to a seperate Request "field" on the Form. Code:
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") )%> ">
I have code that is looking at the userlogin name and then assigns them to a certain value, thereby allowing them to see certain groups of reports on a website. If I want them to have multiple values, how would I code this? This is what I have so far:
I've a multiple checkboxes and would like to insert those values into the db. How can we insert all those checkboxes’ values into 1 field (DB), we use a stored procedure. This is urgent
how i could put multiple values on to a Query String and get them on the next ASP page. Currently on wy website, i know how to get one, but i am not sure how i am able to get more than one assigned to a specific variable.
I am running two queries on a single page and they essentially work, the only problem is that i am unsure exactly how to get one aspect to function properly.
To explain it correctly it will probably be easier to just show you the code, the first query looks like this: Code:
how do get ASP to display multiple calls from a database? For example, I can name a variable for a password, then query the database, then call the password variable later in the code and it should display the password from the database.
Code:
strBody = "Here is your login password: " & strPassword
If in the body of this message I want to have a username on the next line, how do you do this in code? I thought you used a &vblt command, but that throws an error.
i've got 7 radiobuttons with the same name, but them values are different. I need to request the checked values and insert in my field on the database, but how can i get do this separated ones?
i want to submit 30 field(textbox,combo etc.) data into database.if i take all 30 fields on same asp page or form,the page will not look good, so i want to break that into 3 pages,each page will having only 10 fields.when all required fields on first page will be filled by the user then he will click on next button,so he will see next page , i.e. page no. 2,same for page 3.
if he want to come on previous page for editing some info,it should be possible.on 3rd page there is submit button,when he clicks on submit all the info will stored into table. can anyone tell me is it possible using ASP 3.0? if it is possible then tell me how to do this?
I have a stored procedure that requires one variable to be filled: WHERE ItemNo = @ItemNo Instead of sending 1 value,I'd like to send a bunch of values. I don't mind changing the SP if I new how to approach this. The user would select any number of ItemNo's from a form and submit.
Assume ItemNo's like: B1, B2, B3, etc... The end result would be something like ... WHERE ItemNo = B1 or ItemNo = B5 or ItemNo = B10 ...etc....
I want to build a recordset based on the user's selections. How?
I've looked around the net and searched this message board and haven't been able to find a solution to this problem. An application that I am currently making pushes and pulls data from SQL. One stored procedure is very important and returns many values.
I call this sp many times in my script and wanted to put it in easy to manage function, sub, or whatever works. The problem is that it returns about 10 values that I would need to return from the function back to the standard asp. Code:
I have a form on a web page with a number of radio buttons bound to the same field. Is it possible to set up the form so that users can select more than one radio button to submit multiple values to a field in the way that you can, for example, in a drop down field?
I am using both VBScript and JavaScript functions in the same ASP file. All I need to do is to retrieve some values which are calculated in the VBScript function, to JavaScript. The call to the VBScript function is made through a JavaScript function. Code:
I loop through a recordset to return values that populate a form which the user can then edit and save. However these fields need to be validated first to make sure the data entered is correct. I have a Firstname field that returns 3 records from my recordset which means when I try to validate, I get an error as the page doesn't know which of the 3 to use. I believe I have to do it through an array, but have no clue how as my efforts have failed
I'm having problems retrieving all the values from a multiple selection field using the freeaspupload component.
I'm creating an online email app that uses the freeaspupload to add attachement functionality, which means the form encoding type is multipart/form-data. I've done something similar with the persits aspupload component, and had no problems with that, but the freeaspupload version seems to handle <select> fields slightly differently. Code:
I have a difficult technical challenge I'm facing. I need to retrieve multiple values for the very bottom item in the list, 'Federated' (ignore the rest).
The database will query based off the option 'value', however, in this special case I want to perform a retrieval based off of multiple of values. I want to try to use the existing code without reinventing the wheel. Code:
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:
Just as the title says I am trying to do something impossible with a single SQL statement. I am doing an ASP webpage for internal use at the company I work for.
I want to know if there is a way to insert/update data into multiple tables in 1 SQL statement.
If it requires functions | views or anything else that is fine but I don't want to have 3-4 different SQL statements to update 2-3 different columns in different tables.
I have a search option on my website, which should perform a search on 4 fields, as follows:
tblNews headline content
tblDatabank filename description
It only needs to return matches which are an exact match of their search criteria. For instance, searching for "I am here" would return a record which contained "I am here", but not just "I" or "I am" etc.
I need to return all these records as part of one recordset preferably, as I want to be able to order them etc., though I imagine you may suggest I use an array somehow to merge two recordets etc., then reorder them?
I updated to aspx last three month,after developing serveral applications,Idecided to downgraded to asp, following is my reasons: 1.in ASPX,the page format is hard to control,in ASP u can change every html as u like ,but in aspx, a aspx control decide the page format,and its hard to change the format.
2.ASPX is said to be faster that asp, but it is based on too-often communication back to the server,for example,u click a radio a button,there is new page request, but in reality,such a communication is bandwidth-consuming and time-consuming. the user only need to submit the form, and the exchange between IE and Server was minimazed. the Speed of ASPX is not useful for most sites, for bigger sites, the speed increase is singnificant,but for small sites with less traffic, the speed of ASP is quite enough.
3.ASPX is based on Object Orinted Programming, but in most small sites, Procedure orinted programming is used, we never build objects, and POP is more efficient.ASPX is for three-tiered structure with a single layer of business logic component, but in reality, most of us used two-tier structure,that is Presetation layer and Datalayer, we can layout the page and change the database in a single page, quite effienct too.
I want to return a 404 response from an ASP script (IIS 5).
Response.Status lets me set the response string, but if I don't include any HTML text myself, the result is an empty page.
Is there a way to 'redirect' it to the server's default 404 response, as if the URI really doesn't exist, but without really redirecting it so the URL isn't replaced in the browser's address bar?
