I 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:
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 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
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 Replies View RelatedI 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 RelatedUp 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 ?
My work has decided to give me the job of building them an intranet. Being pretty new to .NET and ASP in general I was wondering if anyone knew of books or sites I should take a look at that might help me get started.
View Replies View RelatedI built an ASP Form and I'm using CDONTS to e-mail the results to me.
After the user clicks on the "Submit Form" I use ASP to send a ConfirmMsg
back to the user.
At the same time I would like to send back a Hyperlink .
The Hyperlink will take the user back to some other part of the site, For
Exampe I want to send a hyperlin to
http://www.mydomain.com/index.html
I want the link to appear after the Server processes the ASP Form.
Can anyone help me with the ASP code fot a hyperlink.
When assembling an HTML string from a database before sending it to the
client (ie keeping the connection as short as possible), adding to an
existing string (strOut=strOut & strNextLine) takes time and can defeat the
object.
Is putting each line into an array, and re-dimming the array by +1 each time
quicker? Is there a better way?
When i make a menu box i forms(where you can select multiple options) the result from the form will be something like :
value1, value2, value5, value7
How do i easily build a sqlstring like "select * from tablename where record="value1" or record="value2" or record="value5" or record="value7"
Here is a line of code I have:
matchmakerdetails=fullname & " (<a href='javascript:void(0)' onclick='clearmatchmaker();'>Remove</a>)</p>
This works just fine. BUt what I need is to add code to the onclick such that
document.GetElementById("matchmakername")=""
THe darn quotes/syntax are messing me up and I can not get to work. The challenge for me is that this is part of an asp string assignment to a variable called matchmaker details.
<input name="Name" type="text" value="<%= Server.HTMLEncode(Name) %>" size="50" maxlength="50" onchange="GetName(this.name,this.value)"/>
Email Address:
<input name="Address" type="text" value="<%= Server.HTMLEncode(Address) %>" size="50" maxlength="50" onchange="GetAddress(this.name,this.value)"/>
<a href="javascript: UPDATE(<%=rs("Id")%>)"><img src="SomeImage File" border="0"></a>
Code:
I have a database of quotes on my website that uses an Access 97
database (I'm cheap...I have an old copy of MS Office). I have one page
that builds a form <select> from a SQL statement that looks like this:
SELECT DISTINCT last, first FROM quotes ORDER BY last, first;
The results are 1,250 records from a 3,700 record table.
I loop through the records, using each to build an <option> for the
<select>. When loading the page, it gets to the <select> and then it's
like someone issued a response.end, because it just dies after about 3
seconds. and I get an incomplete page; looking in view source it is
literally truncated right before the form <select>.
Of course it works at home, but not on my "production" site.
I've tried all kinds of things like executing a stored Access query as
adCmdStoredProc, but it didn't help. I'm not even sure if that method
was even any faster when I ran it at home.
Is there anything else that you folks know of that I could try, or am I
just going to have to bite the bullet and come up with an alternative
way to let my users select the source of the quote?
I have an old web app that ues an Access database and ASP 3.0. I need to build an INSERT statement based on the contents of a form. What is the best way to handle blank text boxes that are submitted with the form?
For example, I collect all my name/value pairs that are submitted with the form like this... Code:
I am building an application via ASP that uses an MS Access database to hold inventory for large truck dealerships. I have two columns in the database, one for thumbnails and one for regular (about 450 pixels wide) sized images. The columns in the database hold the URL's to the images in the folders.
I need to create a photo upload that accomplishes the following things:
1. Will re-size and rename the photograph regardless of what the user has it named and sized as. I would like to be able to have the code create the thumbnail and the larger image if that is possible.
2. I need to be able to have that photograph attached to the inventory information that goes with it.
I have a very basic page built, but of course, it does not do any of the "fluffy" stuff I mentioned above. I am not very good with VB and most of what I have seen out there is really contingent upon knowing VB. I tried using a 3rd party application, but to be quite honest, it sucked. Having said that, can any of you point me in the right direction toward having the above features?
http://www.mydomain.com/customer.as...st=il&zip=12345
I build the above link dynamically from the customer's input. It works fine
until they put inthe '#' symbol. The result is the string works up to that
point, then breaks. The trailing information is lost. I use the above to
fill-in form boxes. What can I replace '#' with that will allow the string
to continue? ... and of course, be placed in the form box correctly.
i recently started learning ASP and now i am trying to do some on my home computer.
After doing a few things in my ASP.Net application, i click Build -> Build Solution and then it says this in the output window:
Preparing resources....
Updating references....
Performing main complation....
and then it stays bugged at that section. Then i can go back in build and cancel the building process...
Anyone know what might cause this, my computer is fairly recent and i did re-install Visual Studio .NET to try and fix this problem without any success... I also tried making other applications and it does the same thing...
I have a lot of information to fill out on this form. So I'd prefer not to do the submit to itself everytime to rebuild it. I've seen many java script examples on how to dynamically populate a checkbox, combo box etc. but is it possible just to not have the box there at all?
I've seen a .visible=false on spans in aspx, but can you do something similar to this with plain old asp?
Example, i have a combo box, and let's say i select a few options and write a "on change"..... i call a function that makes an attribute .visible false. Is this possible to make a text box disappear off the page without resubmitting the from? If not, any other bright ideas on how to do this one?
Does anyone have any experience building bar graphs or charts in asp? Or has anyone used a dynamic bar chart generator that is easy to use and easy to integrate into a webpage?
View Replies View RelatedHow do I register that a user has left the website or page? I'd like to show "users online" and "users on this page" counters.
View Replies View Relatedi want to generate the an include file such as
<!--#include file="nav/nav_1.asp"-->
but by calling the number from strNav
<!--#include file="nav/nav_<%=strNav%>.asp"-->
i have several combinations of quotes etc but cant get it to work . is there a way?
I just got a new offer of a company to build them an application framework with a supporting IDE front-end, now the problem is i come from the PHP boards and already checked what Java could do for me but now i find they want it all done in ASP/.net.
Now i know some c# and already read some part's of the books i had at home but i know nothing about ASP, so i bought some books but they cover programming basics which im already familiar with.
Are there any pages that cover patterns done in ASP, schema's or anything i tried the microsoft MSDN page but that's just tooo much information if your not sure of what information you need to contain. Anyway, are there ppl who can send me into the right direction so i can start learning about framework development in ASP or do i need to look further then my nose is long ?
I wish to build a select statement with the "WHERE" part is a variable. I know how to do
Select * FROM table WHERE colum = '" &variable& "' But what if I want the whole part after WHERE to be a variable? with acutal other variables in it.. for instance....
Dim rs, var1, var2, QryString
Set var1 = 1
Set var2 = 2
set QryString = colum1 = '" &var1& "' AND colum2 = '" &var2& "'
rs = Conn.Execute("SELECT * FROM table WHERE QryString")
I am looking for the correct syntax in this case... assume my database connections and such are correct.
I am currently using a single list box and select case to carry out a search for resources on my website. I would like to improve my search by adding two or three more drop down menus to achieve a single, more detailed search.
Hopefully this will help the end user find what they are looking for. unfortunately the current search is rather broad and i need to narrow it down. How do i go about achieving this?