<%@ Language=VBScript %>
<%
Response.Write "<SELECT id=select1 name=select1>"
Response.Write "<OPTION value=1>One</OPTION>"
Response.Write "<OPTION value=2>Two</OPTION>"
Response.Write "<OPTION value=3>Three</OPTION>"
Response.Write "</SELECT>"
%>
When open this page,select1 shows "One".I want when open the page,select1 shows none.That is to say,nothing is displayed in select1.
After qeuering from Access I store the values of the recoredset (like rs.recordcount, rs.AbsolutePage) in variables in ASP, but when i display/use them later in the page it shows -1. but the page shows the queried data properly.
View Replies View RelatedCode:
FOR paging = 0 to recCount/20
IF paging = 0 THEN response.Write("Page") ELSE
Response.Write(" <a href=""favourites.asp?pageno=" & paging & """class=""textareatext"">" & paging+1 & "</a> ")
IF paging < recCount/20-1 THEN response.Write("-")
next%>
how do i not show 1 if there are less than 20 records?
- we've form to be filled. and data will be mailed
- what happens is, mail shows up special characters in places of
commas, and other special characters inputted
following characters are shown in mail content
7E
%2
%0
what can be reason and how to overcome
I have a Combobox and a textbox in my asp page. I want the value of Combobox in Onchange event shows in the textbox. this my code but it isnot correct.
<script Language="JavaScript">
function NavTo(a1)
{
document.forms[0].text1.value=a1
}
</Script>
<SELECT id=select1 name=select1 onchange=Navto(document.forms[0].select1.value)>
<OPTION value="1046">1046</OPTION>
<OPTION value="1045">1045</OPTION>
</select>
<INPUT type="text" id=text1 name=text1 >
I have an asp page that outputs a word document. Wnen the user attempts to
open this page from a hyberlink in an email document the word document opens
fine but if they save then an action cancelled message appears in a browser
window. If you cut and paste this same link into IE and attempt to saves
there is no browser window opened.
If the user attempts to open instead of save the document it opens in a word
out side the browser. I am told this used to open up in word insdie the
browser.If you cut and paste the link into explorer and acess it from there
the word document is displayed in word inside the browser.
If I omit the content disposition header the word document opens inside a
browser no matter how it is opened however the save problem remains.
I do not want the browser window to remain open. Or if it must then I dont
want the ACTION Cacelled message. How can I control that
I have an index.html and redirect in this index to an ASP-page (so a file called XXX.asp). The browser shows me the code of XXX.asp in stead of the layout of the form. How come ?
And when I access this index.html from another machine in the network, I got the error the page XXX.asp cannot be found ?
i want to do is to have an update form that shows tick box data which is read from an access database via asp and a dsn less connection string. Have achieved it with text boxes but can't for the life of me figure out how to do the same with tickboxes.
View Replies View RelatedAnnoying problem on a server with IIS 5. [We have other
IIS 5 that show asp files just fine. I'm at a loss. ]
I can open htm, html, gif, jpg, all files except asp
files. The message when opening an asp file is:
"The page cannot be found...
blah blah blah
HTTP 404 - File not found"
I've looked everywhere. Permissions are okay with IUSR
and security since we can browse other files. The asp
files in question are NOT marked Hidden...
What can I do to make it render the asp files? Ideas?
This is ASP and JScript.
I request a form variable:
var sReviewID = formatUndefined(Request.Form("ReviewID"), "");
Response.Write ("sReviewID: " + sReviewID + "<br>");
Function formUndefined is: Code:
I have an asp page that I use to build the sql criteria for a Crystal report version 10.
The report writer page takes the criteria and supposedly passes the sql string with a where clause to the page that hase the viewer. Here is the code where I pass that script to the report viewer page: Code:
I have a win2k server. I just installed running service pack 3, am just updating to service pack 4 now.
i normally get the error, windows is shutting down in 60mins. pleases save your work. and shows a path to c:winntsystem32lssas.exe
I am wondering if this is a lasser worm or what ? cos i have had to format a couple of times, but still get the error.
what do i do ? Any Advice ?
I have written some code which should dynamically build a table which is then populated with questionas and possible answers. The format of the answers will vary ie they may be in the form of a radio button which will be rated from 1-5, checkbox or a selectbox.
The first problem I have is if I do not comment out <select></select> I get an error message saying the page can not be found. when I do take it out I get asp timeout. Code:
does anyone know what I have wrong with this select in my form?
<%
sql = "SELECT * FROM [LTAB_CAProcessArea]"
Set ProcessAreaRS = Server.CreateObject("ADODB.Recordset")
ProcessAreaRS.Open sql, SessionCPRDBConnection, adOpenStatic, adLockOptimistic, adCmdText
%>
<select name="processarea">
<%
Do While Not ProcessAreaRS.EOF
Resonse.Write("<option name='" & ProcessAreaRS("processareaID") & "'>")
Response.Write(ProcessAreaRS("txtProcessArea"))
Response.Write("</option>")
I don't know if this is in the right section. I hope it is.I have an HTML document that uses tables and stuff. I also have a FORM on there with some input boxes, Radio buttons and <select> options.
I have a .asp VB file also that processes the actual form and writes the answered questions to a text file on the server (tab separated)
My problem:
The input boxes and radio buttons work fine. It writes to the text file on the sever end.
My problem is I am not too sure how to go making the answers from the <select> options to also write to the server. They way I have it set up right now, it jsut writes "NULL" on the text file.
I've recently come across using "Select Last" in an sql query. Does anyone have any info or views on using it? Until now I've relied on "Select Max" but Select Last would have distinct advantages when using random autonumbers. I'm also curious about why there is so little info on it - perhaps I'm looking in the wrong places?
View Replies View RelatedI want to display an editable page extract from MS Access table. Now I want to show the value in Select list, extract from another table. Both tables are joinable with the foreign key.
In simplest, I want to extract and display the exact value from a table and show in Select list for edit.
I could not think of any way. I can bring up data and display in Select list but it would display the first value in the list only.
i want to select all ids from table1 where those id's arent in table2
Sounds simple and iam sure could be possible in a single sql statement
I have the following SQL SELECT statement below that doesn't like the TOP 50 parameter. When I remove it, all is good. When I put it back I get "Incorrect syntax near '50'".
Code:
SELECT TOP 50 SSN, LName, FName, License_Certificate, Character_Identifier, CertificateNo, " & _
"tblIndividualInfo.IndividualID, tblLicense.LicenseID FROM tblIndividualInfo " & _
"INNER JOIN (tblLicense INNER JOIN stblLicenseType ON tblLicense.LicenseTypeID = stblLicenseType.ID) ON " & _
tblIndividualInfo.IndividualID = tblLicense.IndividualID " & strWhere & " ORDER BY LName, FName
how to insert multiple items in a select box into a database. For example:
<select multiple name="ComservGroupAge" size="3">
<option value="Children">Children </option>
<option value="Adolescents">Adolescents </option>
<option value="Adults">Adults </option>
<option value="Does Not Matter">Does Not Matter</option>
</select>
I don't want it to go into my db column as one long field.
for this part. can i use
select sum (orderqty) from custorder
i attach a pic file to show wat i wanted to do
a few data will be listed out
i want the total from that particular few records only. not the whole records in database
I know this is an ASP forum but I've also gotten answers to my SQL problems here and I'd appreciate your help very much.
I have these two tables in SQL. Both tables have the same two columns (Description and SiebelName). I want to some how write a script that will look for the descriptions that matches the ones in Table1 with the ones in Table2 and if there are any I would like to take the column in Table2, SName, and update the column in Table1, SiebelName, with that of Table2.
Here's what I attempted to do but it's not working:
--------------------------------
UPDATE tbl_MasterTEST
SET tbl_MasterTEST.SiebelName = Siebel.SName WHERE (SELECT tbl_MasterTEST.ProdDesc, tbl_MasterTEST.SiebelName, Siebel.SDesc, Siebel.SName
FROM tbl_MasterTEST, Siebel
WHERE tbl_MasterTEST.ProdDesc = Siebel.SDesc)
strSQL = "SELECT * FROM mod48 WHERE N_GEN = 5"
oRs.open strSQL,oConn,3
this table has alot of fields. I want it to automatically create alot of Text boxes for each field. But i also need the fields names. The only thing is that the field names in the table are well not very user friendly.
n_gen = General Numer
pa_name = Client Name
pa_surname = Client SurName
So i was wondering is there something i can do. Like a For each that will create alot of tect boxes for each field "with its value in it" and also make it write a description for the lable. Code:
Ik want to select 2 MAX values form one table, but i don't know how that works, and i can't find it anywhere.
This is what i got so far:
sql = "SELECT max(tekstindex), max(volgnummer) FROM menu"
I want to select max(tekstindex) as 'tekst' and max(volgnummer) as 'volg'.
I have a select statement that searches for certain records within a date range entered through a form. what i need to do on another page is count how many records they are and split them into each day within that date range. My original select query is:
Code:
objRSError.Source = "SELECT TOP 100 PERCENT TrapPage, TrapLine, COUNT(TrapID) AS ErrorVol, TrapDescription, TrapASPDescription, TrapCategory FROM dbo.tblErrorTraps WHERE (TrapTime >= CONVERT(DATETIME, '" & objRSError__strFrom & "', 103)) AND (TrapTime <= CONVERT(DATETIME, '" & objRSError__strTo & "', 103))GROUP BY TrapPage, TrapLine, TrapDescription, TrapASPDescription, TrapCategory ORDER BY COUNT(TrapID) DESC"
For instance i do write out such which works.Code:
SELECT TOP 5 * FROM table4 order by id desc
Now how would i select the rest of the records without the first 5.
I have problem, i'm starting using asp and DB
I have query
sSQL = " SELECT count(*) cc FROM ... " &_
" SELECT count(*) ff FROM ... "
Set oRS = oConn.Execute(sSQL)
First count i can get from oRS.("cc")
How to get "ff"?
I have an ASP application.Is it right that I am calling all SELECT's AND DML's through stored procedures and in the ASP page I just call the stored procedure.
I am NOT using COM,i.e.I am not calling the procedures through DLL's but directly through ASP as time does not permit me to add this layer.
tell me is this right and is this a common practise followed i.e.calling stored procedures directly thru ASP without COM.Also,what is the main benifit of using SP than dynamic queries as there are plenty of suggestions dont know what is the conclusion.
how to filter top 10 records from the recordset. In Access I could use "SELECT TOP 10..." but in ASP it doesn't work.
View Replies View RelatedI have a database containing information in different fields one of those fields is a datetime field, i want to select everything from that table where the datetime field is a monday or tuesday etc.
View Replies View Relatedif the user select the EmployeeID in drop down list, and then click the submit button, and it will look up database and show the Employee Name in the text box, this is easy.
But my case is: when the user select the employeeid in drop down list, it willfire the onchange event, and then look up database and show the employee name in the text box. There is no submit button.
I have a form that contains text fields, text areas and select/lists. The form.asp gets sent through: <form method="POST" action="Confirm.asp"> When I receive the completed form it contains submitted info from all of the text fields ie: CompanyName=Request.form("companyName"), but the responses in the 'select' fields are empty.
Do the select (drop down list) fields need to be coded differently than text fields in order for the response to get posted back to me?
how to place 3 Select Box's on screen? The first Select box will have the category heading. The second Select Box will have its sub_Categories. The third Select Box will have that Sub_Category's Products.
View Replies View Related