as i enter text in the textbox i want to narrow down there result in the box below that has all the listing of the products. i.e as i enter 'a' in textbox it will filter all products starting with 'a' then if i enter 'b' as second character it will show onlythose products that are starting with 'ab'... so how could i do that.
View RepliesI have a recordset that returns company names, their are duplicates, sorted
by company name.
sCompanyName = ors("company")
How can I show only one company name from each company and display nothing for the next name if its the same in the previouse row,
COKE $2.14
$2.16
$2.16
PEPSI $3.13
$3.11
$3.12
FANTA $1.26
$1.26
I have an MySQL query that counts the number of clients that have been added in the last week.
strsql = "SELECT COUNT(visitorref) As no_visitors FROM visitors WHER datediff(curdate(),date(loa))<="&weekday(date())-1&" AND client_count IS NULL"
This works fine for Monday through Friday. But, I want to change the week etaphorically speaking! ) to run from Thursday to Wednesday, so on a Tuesday it'll show the count from last Thursday to the Tuesday.I'm gradually beginning to think I can't do it this easily anymore and just can't figure out what I want the datediff to equal.
i ussually use www.domainname.com?uid=1111 .this one use request.quarystring right?so, what is the logic to change to www.domainname.com/1111
View Replies View Relatedi was building a internet based search engine and heard of fuzzy search algorithms.
Can anybody give fuzzy logic search algorithm for string search.
Write an exe/dll (which will be better please tell me)..which has code to only control my logic or rather data conversion/manipulation of the raw data recieved thru and .mdb file and then display the exe/dll manipulated data thru an asp page.??
View Replies View RelatedI am working on this for someone: the user sees a list of chocolates which they can click on to add to a virtual chocolate box.
Each choc. is represented as an image of the choc - clicking on the image adds that choc. into a db. storing the product id of the selected choc. The user can select 8 chocolates. When the box is full, they can select no more chocolates.
I loop through the db. to display the number of chocs in the cart, like this: Code:
Up until now I have mostly used a script that I got from somewhere way back for adding the page navigation on a results page ie.
<< 1 2 3 .. 4 5 6 >>
Ive decided to make my own but there seams to be too many cases/options in my script.I am using an array to store my results so if anyone knows a place where I can view a simple one or even some logic behind it.
I've been looking at pure ASP solutions to uploading a file from a form, and I'm a bit confused just on the logic.Each solution I've seen includes a binary read of all of the POST data and a parse to find the file.
Why can't the request.form collection just be used to get the binary directly? I mean, even if the request.form collection reads an ASCII value, isn't ASCII just an interpretation of binary (so shouldn't we be able to simply write it to a file and be done with it)?
We need to create an org chart from our employee data but struglling. We are using ASP with SQL Server 2000. Does anyone know of a commercial component or some sample code to help us get started?
Ideally a component will be great as we need to turn this around quite quickly and also the chart needs to be interactive so various nodes can be hidden or expanded by the user. Many of you have been in development and I am sure would have been asked to present the employee or similar hierarchical data in tree structure.
I have created a dynamic form ,different under different conditions. The elements of the page are dynamically created with the required infor . coming from tables. Now, i have to store the values, states of all individual elements of the form, for future processing . The values are the part of a survey. I hav to analyse the values and create a report.
Now , i m getting confused in the way , the values of all dynamic fields to be stored. I m not getting a good way to store the values and later process for survey analysis.
i am having a hard time finding out whats wrong i get the users login name from the first page and then i have this page which displays the abstracts
whats happening now is if the user has 9 abstracts assigned to him he sees 5 abstracts on the page and then there is page navigation so he sees the number 2 when i click on number 2 i should see the rest 4 abstracts but i cant see anything it doesnt give an error can anyone tell me whats wrong Code:
I am using access with sch_time_start,end,start_time,end as text fields not as Date/time....I am getting wrong amount of record...Example:
If db has 6 records like start_time and end_time = 12:00 AM- 05:15 AM,
and person has sch_time_start and sch_time_end = 12:15 AM-05:12 AM.....I am missing smth...maybe logic is wrong.. Code:
Something is not right when I generate the results for assigning drivers to routes...My [ response.Write(rs5.recordcount & " " & rs5("Tot") & " " & rs1("Full_Part") & "<br>") ]
The rs5("Tot") is always zero when the recordcount is 1...with rs5 I am trying to control not to assing more than 42 hours for full timers and 22 hours for part-time drivers per week.... What is wrong with the logic ?
I'm trying to put the 4 latest(by publication date) articles published in my press table on the front page of my site. What's the logic here:
Show only the 4 latest articles
and if there is no addition to the article db:
Show latest articles for 1 month.
I am displaying a list of data from a sql database. I have hyperlinked each field as i want the user to be able to click on this link, the page refreshes and all entries that are the same as the user clicked on are at the top of the list. I am using a query string as the link.
View Replies View RelatedI'm listing events held on an Access database displaying the forthcoming events using a For Next loop (is there any easier way?).
Some of the events are considered important and to be listed if they have a value of "y" against them in a field called "important".
How would I list say the forthcoming 4 events plus ALL of those where important = "y"?
I'll get right to the point. I'm displaying an alphabetical listing of names from a recordset in the following manner:
A
abe
alex
...
B
barb
bob
...
C
craig
etc...
Presently, I'm using a for..next statement to cycle through the alphabet, and displaying the matching names for each letter via a loop. Here is the code:
display just a listing of files in this manner.For example.If i select D: drive it should give me all files in root directory and sub folders and sub sub folders.
The operation is like a dos command
dir /s/o/b
I am using this for sitmap for one of my client, who has more than 100 folders and 50 sub folder and 10 sub sub folders
that he has more than 7000 html pages
I am tring to build a registration online form that participants will be
able to choose from about 75 diferent courses divided into various sessions
and choosing a course per session.The problem I have is that I cant figure out the best way to do this:
1. either to make them static pages and then submit the values the
participant chooses into a database and use the values for billing etc. Like
this i will be able to validate / control what the users chooses e.g they
dont choose overlapping courses.
2 my second option is to list them in a database and then list them on my
page , which is easier but how do I validate what the participant chooses
and how do I move the values to the next page and making sure the right
course goes to the right session.
Is it possible to list directories of different computers in a network?
For instance, I have the script on "server 1", "server 2" is another computer in its network places under the same domain. I want to have a asp or asp.net script list the contents of "server 2" from "server 1".
Is this possible? all the asp scripts Ive seen so far can only list files from the computer/server its on.
I've managed to get file listings, do textstreams, move around in the file system a bit, just wondering how I get folder listings as I would file listings...
Here's what I've tried, but it's not quite working:
[vbs]
strPathInfo=Request.ServerVariables("SCRIPT_NAME")
strPhysicalPath=Server.MapPath(strPathInfo)
Set objFile=objFSO.GetFile(strPhysicalPath)
Set objFolder=objFile.ParentFolder
Set objFolderFolders=objFolder.Folders
For Each objFolderItem in objFolderFolders
mess=mess & "<tr><td><a href=""" & objFileItem.Name & """>" & objFolderItem.Name & "</td><td></td><td></td><td></td><td></td></tr>"
Next
[/vbs]
I want to display a list of businesses from a database but break on each new letter eg
A
Andrews Carpets
Arthurs
B
Browns Bakery
etc etc
I haven't a clue how to do this, can anyone help please?
If I'm displaying records from a db as a comma seperated list with a full stop at the end what do I need to do?
Example: item1, item2, item3, lastitem.
I have a do until rs.eof loop which which displays each record like so:
<ul>
<% do until rs.eof %>
<li><%= rs("item") %>,</li>
<% rs.movenext %>
<% loop %>
</ul>
I have been searching google and other search engines and have not come up with anything for this question of mine. Maybe I'm not typing in the right stuff.
I am writing a couple of scripts that require me to display a list of information from a database from one catagory. I have never needed to do this before and am trying to find out how I should go about doing it
I have 2 textboxes - "from" & "to".
Assume I enter number 1 in "from" and 10 in "to" - I want the ASP to return:
1,2,3,4,5,6,7,8,9,10 and insert this into an Access database over 10 rows
into the 'number' field.
Anyone got any ideas how to do this?
At work I was asked to add a link to a directory listing page. This page is with the link is located behind a secure page requiring a username and password. When I added the link I also went to iis and checked to make this directory have directory browsing listing checked.
Everything is fine however now this directory is open if you just post the complete link to it in the URL bypassing the login page. Is this a nornal behavoir and is their anything that can be done to make it prevent it to be opened?
I'm trying to list the contents of a directory but only showing file types of .txt and .mdb
View Replies View Relatedanyone know of a good ASP Application that will allow me to do featured listings/ or sponsored listings on a page? These need to be text based links - like google style probably.
View Replies View Related<code>E-Mail: <a href="mailto:<%= cn_shr("EMail") %>" class="fontLinksDark"><%= cn_shr("EMail") %></a></code>
What the above code is supposed to do, obviously, is write a person's e-mail address out, and at the same time include that address in a hyperlink so that someone could e-mail that person. The problem is that it doesn't show up. There is no error code or anything- the output just does not show up.
I would like to list all files and folders on a password protected directory (basick auth). I know how to list all files and folders in a normal directory but i don't know how to do so for a password protected one, due to the fact that i couldn't find any article/book that explains how to do so and also the fact that to the best of my knowledge there is no way to pass a username and a password to the File object in order to authenticate to the webserver as an other user, all i could think of was to pass the user/pass to this directory in the header (with response.AddHeader ) but that doesn't seem to work (even though i am not sure i used the correct syntax for the header).
View Replies View RelatedI have an access db with 5 fields, ID, Category, BusinessName, Address and Phone. I want to list the records like so but can't think how my loop and check to see if the category has been changed should look. Can anyone help?
<h2>Category1</h2>
<ul>
<li>business name</li>
<li>busines name</li>
</ul>
<h2>Category2</h2>
<ul>
<li>business name</li>
<li>busines name</li>
</ul>
I have an Access Database with only one table (tblBooks) with 5 fields: id, TestNumber, Book, Author, ReadingLevel, PointValue. I would like to have alphabetical listing of the records displayed by hyperlinks on the top of the page like:
<Previous All | A | B | C | ....| Y | Z | Others Next>
Also would like to have only 25 records per page and bottom page numbering. I know this is a newbie question but I haven't being able to figure it out.