I'm trying to develop an SQL request that will give me back the full contents of the table 'bbs', appending two COUNT()'s from the table 'topic' to the end of the recordset.
The condition of the COUNT()'s should be that bbs.forumnum = topic.forumNum. Therefore if row 1 of 'bbs' has a forumNum of 1, then the append data should COUNT how many rows in 'topic' also have a forumNum of 1. Code:
Ive got a script here that searches using info from querystrings. it's just a snippet from the other lot. Code:
View Replies View RelatedI was wondering If there is any way to grab just the viewable text of a webpage
using xml. Not the html, just what the user can see.
I am having trouble with installing IIS, I tried to do it in my control panel, but it wants the disk, I don't have the disk because my computer came with Windows XP Pro 2002 Service pack 2.
so I went to the microsoft website and downloaded the free download of IIS6. Then when I go to my control panel and Administrative tools it is in there and when I click on it, there is no computer name available.
I have two recordsets that I want to populate within an array.
The array will always have two columns, but the number of rows is unknown (sometimes 2 rows other times 200 rows). I'm not too familiar working with arrays.
I want populate the array using a loop. How would I define and populate the array within loop so that I don't lose values and each new set of values are populated into the array through each iteration of the loop? Code:
I need to dynamicaly create my javascript as the page loads because as persons add items I need to increase my layers based upon the number of records returned from a recordset. Code:
View Replies View RelatedCan someone point to an example where dynamic drop-downs are populated? I would like to execute a sql statment and populate the items in dropdownbox1. I would also like to retrieve all possible values for dropdownbox2 and use Javascript to build an array that holds these values.
Then, I would like to scroll thru the array to select the correct values for dropdownbox2 based in the selection made in dropdownbox1. At last I would like to save the selected values for dropdownbox1 and dropdownbox2 to the database. I would appreciate very much if someone can give me code examples for each of the things listed above.
I'm orking on an online Catalogue, users are to select from a dropdown menu the finish they wish there goods in. The way I was thinking of doing this is have the finishes availiable stored in a column in the database - lets say 'finish' and the column would contain the finishes seperated by commas.. like red,blue,green,yellow etc, so the pull down menu would need to dynamically populate with these values.. is there an easy way of doing this, or am I going about it the wrong way?
View Replies View RelatedI am populating the few fields values from one of the table. I put series of checkbox having same name but have a different value ( value of checkbox is small int, an autoincrement field of table).
I have to take action against the selection of checkboxes. If the user check one of the checkboxes and select "Approved the things " then the USER will move to some else page and the selection will Approve.
On the contrary, if the user opt delete the things then user move to other page and record will be delete from the table.
Now my problems is...
1) how can I know which checkbox user selected ?
2) Are there someway to get the value of checkbox without making form ?
i am trying to create a drop down with information from a db. i am clueless as to what to do.
View Replies View RelatedI am trying to populate a drop down so that it shows the current date, plus the previous 6 days. Here is some pseudocode. I can't get it to work from here.
<SELECT name=Date>
<%
Dim d
d = Date()
for i=1 to 7
%>
<option><%=d-i%></option>
<% end for %>
</SELECT>
I have a check box, when selected it needs to trigger "something" to populate two drop down lists with default values. I haven't done this before, so I was hoping to see if somebody had a good example willing to share.
I was doing a research now and realized that I also need to mention it needs to populate values straight away not on the submission.
I need to populate a dropdownlistfrom a form and fill it with the numbers from 1 -1000. Obviouly, this would take a considerable amount of time doing it manually so how does one go about populating this list from an array of some sort?
These entries will be stored in a database so would it be better to just populate this form from a database? After mentioning the above situation(s)... (a)How do you fill the dropdownlist from an array? (b) How do you fill the dropdownlist from database explained in it most simplest form?
Is there a way to grab a password entered into a login page, and have it populate a field in my table?
View Replies View RelatedI have a recordset full of a list of courses.I want to create a search page, where the user can select the course from a drop down box, hit go and be taken to a page on that course. But some courses have 3 versions of that course, so for example I have 3 IT courses. so in the list it says
IT
IT
IT
How can I limit this to just display the value once in the drop down?
I am trying to make a page to display a comparison chart. say we have 15-30 products... these products are all similar and we would like to compare them to each other
I would like to have an image (or whatever) of each product and then a check box next to each one. Below the products is a table (with say... 5 columns) with all of the attibutes of the products (this table is EMPTY otherwise)
when the user checks the check box.. the first empty column populates with the info (from a file??) and the user can continue checking boxes until the 5 columns are populated, or the user can uncheck and have the column unpopulate
i have a LITTLE (very little) asp.net exp. but i understand the concept (same with SQL) and plenty of HTML and such... can someone help me put somthing like this together?
I want to populate my ASP page consisting of some form fields as follows.
As the user enters data into the first field. That value is used by say a javascript routine triggered by "onblur" to fetch values from a oracle database and populate rest for the form fields in the ASP page.
Can this be done?
i have several radio buttons and a combobox. i want to know how to make this combobox enabled only once a radio button is checked and populate it with data from access database depending on which button is checked.
View Replies View RelatedI have a sign-in box that is an IFrame, with a form target of "_top", and
the current (parent) page URL as a hidden field.
If sign-in in successful, there is a response.redirect to the page URL,
having set the session variable LoggedInOK=true.
However, if the sign in is not OK, I want the IFrame to be the target, (i.e.
_self, not _top) to display the error.
Is there a way for ASP to control whether it redirects to _top or _self, as
setting the form target in the Login page requires "pre-knowledge" of
whether it will be successful.
I am moving a ASP website to a new Window 2003 server with
IIS 6, but an error occur for the metadata declaration in
my global.asa
<!--METADATA TYPE="TypeLib" NAME="Microsoft Scripting
Runtime" UUID="{420B2830-E718-11CF-893D-00A0C9054228}"
VERSION="1.0"-->
the error message is
Active Server Pages error 'ASP 0223'
TypeLib Not Found
/LM/W3SVC/1/Root/myweb/global.asa, line 4
METADATA tag contains a Type Library specification that
does not match any Registry entry.
I'm writing an Online registration system for my friends new business.
I'm trying to incorporate checkboxes so when a person checks on 3 or 4 checkboxes and hits the Submit button I can
pass the information of what they checked_on to a new page.
When I get to the new page I would like to update a database, based on what they checked_on on the previous page.
I'm not sure how to do this.
I'm not sure how to pass the information.
using PWS on test machine (NT4 workstation SP6) and everything was fine but cpshost.dll was used in the website we're maintaining, so I idiotically installed it from a Visual J++ disc. now the website works fine but when i navigate to 127.0.0.1 nothings happens. I've checked directory browsing is enabled but still nothing happens!
I'm aware that cpshost.dll was never meant to be used on NT workstations but as I said before the upload functionality works fine, it just seems to have screwed the directory browsing up - and also the code document.referrer equals nothing.
I am primarily a front-end designer and not familiar with ASP beyond
breaking up pages into include files. Recently, one of my freelance
clients wanted to display an RSS feed from his blog on his site. I did
some research and found the rss2html.asp script. I chose this over a
javascript solution because those scripts apparently don't affect
search engine rankings.
I implemented the script and it was running fine until about a month
ago, when the site and sometimes the server running it started to
crash. The ISP and the blog company the RSS feed originates from blame
the script. Bytescout, who wrote the script, says that it's probably
the feed that's causing the problem. The RDF version of the feed
validates as RSS, but the ATOM one has specs that are too new for the
validator to parse correctly. Code:
I keep having trouble connecting to my database I am running windows xp pro and Access 2000
Error Type:
Provider (0x80004005)
Unspecified error
/test.asp, line 60
It keeps bringing up the above error message sometimes it works fine then other times it dosen't has anyone had any similar problems.
i'm working on access db the problem is when i enter date in d/m/y format it wrote db m/d/y format but this happens only with small numbers i.e if date 04/09/2002 it become 09/04/2002 in db but if it is 24/09/2002 there is no problem.
View Replies View RelatedI've narrowed down my error to one particular function. It looks as if the function may not be receiving the variable that is passed to it.
The error message is:
error '80020009'
results.asp, line 21
Line 21 is: Code:
I'm having some trouble parsing an XML document I'm getting from my company's bank in response to a XML document I'm sending. Both docs are transferring fine, and in fact if the transaction in the document I send is accepted (valid credit card), everything parses perfectly.
The prob is when the transaction is not accepted by the bank server (invalid credit card), and the document that's returned to me has different tags. Code:
I am having some problems populating a drop down menu called province with data.
This is the error I am receving:
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
/fairmont/order.asp, line 85
I am sure there is data in the DB. I have attached the file.
I managed to import Microsoft Word table structure into my code, but the problem I'm having is that the field are not being populated. Code:
View Replies View RelatedThis code only allows for 1 date from my database to be added. I need to be able to populate it with all matching dates. I'm not to sure on how to do this.
<select name=""select"" size="1">
<option value="date"><%=get_notes("date")%></option>
</select>
What is the best method to insert and retrive image to and from the database?
View Replies View RelatedI have an access database with about 5 tables. One of which i want to populate data to. Specially 1000 enties at one time(In this example im adding employee numbers to a database table. Initially i want to add the for the employee name field " Unassigned" and when i ready to append a real employee name to the fields add if through a script(Can this be done?
Or is there a better way to do this?)This way, in my script i can call one of of those 1000 entries or employee numbers from a dropdowlist (ex. 1-1000). This way if go to use one of those entries from the dropdownlist the database would not get the " EOF/BOF error ". What logical suggestions do you guys have ?
im looking at populating a drop down box with database values when a user selects a value from another drop down box.I have a drop down list that populates from database values, it is a list of manufactures. When a user selects a manufacture i want it to display all the systems for that manufacture which will be stored in a table. I understand that because asp is server side that once an option is selected the page would have to submit and then load the values in.
View Replies View Related