I do not write the whole code.
I have a IF statement like the following.
if request.Form("UyeTipi") = 1 then
strsql=select ****
else if request.Form("UyeTipi") = 2 then
strsql2=select *****
this is the recordset
set objRecordset = objConnection.Execute(strSql)
With loop I want to display data either from "strsql1" or "strsql2"
I create table like the following with loop
Code:
i want to do a voting, which let user select. how can i count the number of user vote?
n... how can i accumulate each slection and display a chart by percent?
example:
.apple
.beer
I have a web page where a user can select a location out of a possibility of 5. I also give them the option of seraching all 5.
However when I put this in it get rids of the drop down box and puts them all in an open box about 2 inches in length. Which isn't too bad but if I say had 20 locations it would take up half the page.
I have a form field called Streets that contains 'HIGH STREET,MAIN STREET'
I have a field in my access db called StreetName a single record would contain one street and I want to return all records that have a StreetName in the Streets field. How would I go about this?
I am working in an asp/Vb script environment.In a form I have 2 combo boxes.first is main criteria and second one is sub criteria.in the first combo I have made predefined enteris(the headers of the table)say a table is:emp and its headers are:empid,empname,L1manager,accounts,location etc.
on a change event of first combo,I want to fetch the details from the table.say if I selected Ename in first combo.the second combo should automatically fetch the listed Enames and vice versa.
My left frame contains a combo box which loads the selected record in the main frame.The combo box retrieves concatenated 3 columns from my db. E.g. ID, Firstname & Surname.
Because of this, it seems to blow out the size of the frame,thus ruining my nav system.Does anyone know how I can restrict the box width, but allow the drop down part to remain wide?
How do i select a completly random record from a database?
sql = select (random) from tbl, sort of thing.
I have searched through a lot of paging articles. But I have not found any specific recommendations for my issue. I have a large record set that I need to page through (1000 records). But on each page (100 records) I must be able to select some rows, add
some comment for each and sumarize them on-the fly.
if I page forward and backward, I still need to see before selected rows with comments and I can even deselect or edit some of them. Should I store all this information (selection, comment, price) in session variables or is there a better way?
I am working in an asp/Vb script environment. In a form I have 2 combo boxes. first is main criteria and second one is sub criteria. in the first combo I have made predefined enteris(the headers of the table) say a table is:emp and its headers are:empid,empname,L1manager,accounts,location etc.
on a change event of first combo,I want to fetch the details from the table. say if I selected Ename in first combo. the second combo should automatically fetch the listed Enames and vice versa.
My site is running on IIS5.0 hosted on win2k service pack 4 m/c. We are going to procure high end windows M/C . I seek your advice in selecting right os and version of IIS. My comp is a bit hesitant to migrate to .net too (I don’t know planning of comp in future).My requirement should be
1) Same Program should run on new server with minimum changes.
2) If required we can migrate to .net (although planning is not in near future and I even don’t know what is needed for that)
Your advice in this regard is highly appreciated. Also if you can explain in short about new feature in IIS6.0 (or upper version). Which version of IIS come along with Windows 2003 server, I really have very little knowledge in this field.
i am using frontpage ,ASP, and some javascript. how do you create a START-> ALL PROGRAMS selection option. you place the mouse over the "all programs" and you got all selection related to "all programs"
i want to do the same thing with data from a database. how do i do this?
I have this code the value thats stored in table is Yes in College_Assistance field
so i want to select the Yes radio button
but its not selecting
when i see he view source it doesnt say checked="true"
any idea why. Code:
I have a selection list of the 50 states that is not dynamically built. If &state=CA is in the query string i want the selection list to automatically select CA out of the selection list since that is what was in the querystring. Know what I mean?
View Replies View RelatedHas anyone used the UPS e-tools such as address verification and rate selection service? I'm trying to implement it on our site and I would just about kill to see some source code. It's a little above my coding level and I just can't seem to figure it out.
The documentation goes into a VB sample, but I dont think that is necessary since you can perform an HTTP POST and parse XML in an ASP page.
I am trying to show some stats. However I have four levels to choose from, which are shown as true/false. I want to count each entry by employee and categorize it only under the highest level achieved. One entry can have multiply Levels. Hope this make sense my mind is a little foggy today.
Here is the sql statement I am using. I have added the levels as or however I want to count each level but only the highest level achived. I don't know if it would be easier to do this in a SQL statement or in vb script. Code:
I have 4 radio buttons
<input type="radio" name="One" value="One" checked
One
<input type="radio" name="Two" value="two"
Two
<input type="radio" name="Three" value="Three"
Three
<input type="radio" name="Fout" value="Four" >
Four
How do i remember wich one was selected when the page is posted back.Meaning having all options back with the selected one being checked.
I have a webpage where there are two drop down menues. From each of them, one item can be selected. I need code to test if there was an item selected from both the drop down menus. How do I do this? Do use ASP or HTML?
View Replies View RelatedI have the following drop down menu on a html page and when submitting
i would like to call out on asp what someone has selected.
<select size="1" name="type">
<option value="Prospect">Prospect</option>
<option value="Suspect">Suspect</option>
<option value="Qualified">Qualified</option>
<option value="Proposed">Proposed</option>
<option value="Closed">Closed</option>
<option value="Lost">Lost</option>
</select></b></p>
I also have regular fields on the html page which works great when
submitting but for some reason i can't get the dropdown selection to
display Code:
How can i retrive random row of table in ASP.i have a table created in
access2003 and i want to show randomly selected row to the client.is
there any way to do this using recordset object.
I have a script that has worked flawlessly for a while. It allows a user to select from a listbox - with highlighted lines already of their settings, multiple lines (CTRL-SHFT) and the page updates the database properly.
Now, for some reason, I have a user that when we load their settings, all is fine. If I submit the form, immediately, with no new additional selections, all works fine. But, if I add even one new selection on the list box by holding CTRL-SHFT, the submit button no longer works at all.
This user does have a long list of selections already, I am just wondering if I may have hit a max some how?
Is there an SQL query which select an item from the database randomely!
View Replies View RelatedI have a dropdown list where u can add students name inside the listbox. As u can see there is a "Please select one" option in the dropdown list also. When i click on the option, it will be added into the listbox also. Can someone pls help me to solve this in JavaScript. My attachment.
if (document.teamForm.newMember.value == "-- Please Select One --")
{
alert ("You can not select this option.")
teamForm.newMember.focus();
return false;
}
I have used the follwing query before in SQL and its worked fine but not on an access database is the syntax different?Code:
strSQL = "SELECT Count(DISTINCT BID) as varAmount FROM Bookings Where BookedBy = '" & rsStaff("Name") & "'"
The Error i recieve is:
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'Count(DISTINCT BID)'.
I have three sets checkboxes in my .
Checkbox a,b,c with different names
If a user selects checkboxes in set A. He cannot select any check box in set B, but he must select in C. If a user selects check boxes in set B. He cannot select any check box in A and C. If a user selects check boxes in C. He cannot select any check box in set B, but he must select in set A.
i have 5 checkboxes in one asp page, I am trying to get the values of all checkbox that are checked using for each loop but I dnt get any result,just a blank page. Herez my code where I am trying to get the values of all check boxes
Code:
for each cid in request.Form("chk")
response.Write cid & "<br>"
next
i have an access database with 5 records in and i need to show them in a random order every time the page is refreshed or reloaded. i've searched round and tryed no end of code but nothing seems to work.
i just need something really simple that selects a random feild from my DB. Sql = "SELECT * FROM tblmain ORDER BY RND()" - ive tryed this and it just shows the results in teh same order.
i have 5 checkboxes in one asp page, I am trying to get the values of all checkbox that are checked using for each loop but I dnt get any result, just a blank page. Herez my code where I am trying to get the values of all check boxes:
for each cid in request.Form("chk")
response.Write cid & "<br>"
next
I'm creating a bilingual site for an Intranet. The site is created with a modified version of NukeEdit. The way it works is I have 2 completely seperate sites that are identical for both languages (other than the content of course).
To make things simpler all the files and folders are named in English so the directory and file stucture for the site is the same for both languages.
On each page there is a button to switch languages. The thing is I have the button linking to the homepage. I would like it to be a bit smarter and take you to the actual page you're in. Code:
Is there any way to select mutiple files from Client machine's drive for uploading?
View Replies View RelatedI have a list box that allows users to search an SQL database on ZIP, Name and so on
After the submit the List Box selection always goes back to the defaut selection.
I figured by writing the current selected item to a cookie prior to the submit I could recall it upon reload.
Does anybody know how to set default selected item for a list box? Am I going about this the right way? The more I research it seems dynamically creating the list box is the way t go
At the moment i'm working on a template based newsletterscript and this a testscript to get some variables. This is actually working for one record but i want it to get al the records where the Newsid = "1" e.q.
It's not necessary to print/ write the results but this is just testing.
Actually the following part should be a select case... depending on the value of the column = template e.q "1" he should display this record in another format. Code:
I am having 66 radio buttons on my page. Each ll be having 3 options yes,No or N/A. By default all will be set to No. My requirement is if i click on a button, value of all radio buttons should be set to N/A.
View Replies View RelatedI have a dropdown box with a list of values. How can I save the selected value back to an Access database?
how can I retrieve the stored selected value from the database and make sure that is the option selected in the dropdown when the page is redisplayed back to the user at a later time?