Building <form> From Recordset
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?
View Replies
ADVERTISEMENT
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?
View Replies
View Related
Users enter data using HTML forms and it gets processed by an asp page that enters the data into the database. What I am trying to do is get a "confirm" page set up that will make sure the form was completed properly. If it is completed successfully, then the data from the form needs to be forwarded onto another asp page that will enter the data into the database.
My question is, what is the best way to forward the information on? Currently I am using querystring to handle this, but that doesn't work in some situations especially when one of my forms has a <textarea> box that seems cumbersome to send via querystring.
Is there a method I can use to easily forward the data from the form to subsequent pages after the first one ?
View Replies
View Related
I´m making a asp page which creates a xml-file. The values for the xml-file will be calculated in a stored procedure. This procedure returns 3 recordsets. In my query analyser the stored procedure returns the right values. The problem on my asp page is that the stored procedure is executed, but the recordset is empty.
This is the error message from my internet explorer:
ADODB.Recordset (0x800A0CC1) Item cannot be found in the collection corresponding to the requested name or ordinal.
This is the code i´m using: ....
View Replies
View Related
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 Related
I 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.
View Replies
View Related
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?
View Replies
View Related
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"
View Replies
View Related
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.
View Replies
View Related
<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:
View Replies
View Related
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:
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
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:
View Replies
View Related
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...
View Replies
View Related
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 Related
How 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 Related
i 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?
View Replies
View Related
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 ?
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related
My ISP provides a web based email client, but it is not brandable and the features are not that extensive. I'd like to build my own. Has anyone done this, or is anyone aware of any tools out there to do this?
View Replies
View Related
I could do with a little help with the code below,
<input name="order" type="hidden" value="prod=<%=RS("product_name")%>,item_amount=<%=RS("product_price")%>x<%=RS( "cart_quantity" )%>;prod=SHIPPING, item_amount=<%=postage%>">
I am trying to build 1 hidden input field only, the input is inside a while not EOF loop,
currently the code above is building an input field from each product record, so i get one hidden input from each item, what i think i need it to do is build a string from the records and then put it into the input field i.e. the final input field should look like this: Code:
View Replies
View Related
We use an ASP application in which we send out emails using cdo for various
events.
At present the email text is hard coded into the code. for example
strMessage = "Dear " & rs("firstname")
strMessage = strMessage & "Your request has been approved with reference id
" & rs("id")
This causes an administration overhead as everytime the text of the message
needs to be changed we need to alter the code to incorporate text or
database values.
What we want is to store the message text into a table so it can be altered
by the application administrators through GUI by adding the text through
freetext entry and field names though a dropdown. Code:
View Replies
View Related
I have a asp page where part of the code is as follows. This builds up the sql statement partially.
sql01 = "UPDATE EquipmentTbl SET "
sql01 = sql01 & "SerialNumber = '" & request.form(strSerialNum) & "', "
sql01 = sql01 & "Description = '" & request.form(strDesc) & "', "
sql01 = sql01 & "Location = '" & request.form(strLoc) & "', "
RESULT OF PARTIAL UPDATE STATEMENT USING RESPONSE.WRITE IS:
UPDATE EquipmentTbl SET SerialNumber = 'A83737', Description = 'Video
Conferencing Equipment', Location = 'Conference Rooms cabinet',
Now, in the above, I would like to be able to put the location field as 'Don's room'. In other words, I would like to handle the aprostrophe after Don. With this in mind I am changing the code as following: Code:
View Replies
View Related
Last week, my shopping cart was still working well until I began getting the following errors 2days ago..
Error Type:
ADODB.Recordset (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
../order/saveorder.asp, line 157
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)
Page:
GET /main/saveorder.asp
Could you check my code below and let me know what possibly the error is?
View Replies
View Related
My well-heeled clients would like a tool that I could build into a web application that would suck down the entire contents a remote webpage and store it on a local filesystem.
I know how to scrape textual content from places on the web using MSXML and assorted scracping widget. That doesn't help me for photos, nor does it answer how to encapsulate the photos in a form that I can see them.
This would probably only find use in intranet-type situations, so a IE-only ..mht-type encapsulation of the page might be OK.
I have OK skills working with the FSO, so if there's a widget or method by which the retrieval can be done, I can probably figure things out.
Has anyone done anything like this? Can someone suggest widgets and/or a design approach?
View Replies
View Related
I am to build a site onto an ASP server. Anyone here used Dreamweaver and is it just a simple matter of opening up a new ASP page in Dreamweaver and build the site like you would normally do with a HTML page and it will handle the ASP coding accordingly and you can just simply upload it onto an ASP server and it will work?
The site I am to build is basically just a standard html website, but my friend wants me to build it for an ASP server so he has asked me to make sure it is an asp site so I am presuming with the extension .asp
If I build it as a html site to begin with, will converting it to asp be hard. Could I just export my pages into asp or is there more to it?
Can a Html website be loaded and working on an asp server or host?
Is it possible to have a site mixed both html and asp, eg. the home page is html and when you click on shopping cart on the home page it goes to a hopping cart page thats .asp or do they all have to have the same extension.
View Replies
View Related
I have created a forum, in which I have 3 tables:
1: Table_Forum
2: Threads
3: Replies
I have it at the moment that on the main default.asp there is a recordset that will
display all records within that table, these are a list of forums that will be available.
I have a table that will show the forum name, and the description. This table is then looped using Do while not, now what i need to do is show how many records in the Treads table are related to each forum using asp. Code:
View Replies
View Related
I´m having a problem using ASP Upload with an insert form..
If I use ENCTYPE="multipart/form-data" the all the parametres i might get with request.form don´t appear.. but i can upload the files.. Besides if I take away the ENCTYPE tag, i can´t upload but the INSERT INTO form works propertly
View Replies
View Related
my form contains two text fields(name, address) and two file field control where user can insert image(photo1 and photo2), i want to insert this data in to ms access when the user submits the form?
this is my code for insert text fields to access data base.but i have no idea about the code for image fields. In my access data base i set photo1 and photo2 as herf (binary data). Code:
View Replies
View Related
I have a form that is dynamically generated since it is populated with values retrieved from a database. The form can of course also be submitted, which is where I run into some problems.
Since I never know in advance what the length of the form (or for that matter what the different elements' names and values) will be I don't know how to write the code in "receive.asp" to retrieve all values from the form correctly without excess use of "request.....".
I shouldn't have to write requests for every single potential element name that is stored in the DB. Please note that the form can sometimes also contain radio buttons and check boxes, even though they are not present in this short example Code:
View Replies
View Related
I have a form as follows:
<form action="dropboxsubmit.asp" method="post" enctype="multipart/form-data">
<input type="file" name="FILE1" size="30">
<input type="text" name="def" value="0" size="10">
etc.....
and can't get my asp to recognize data in other form input boxes using Request.Form
Any thoughts?
View Replies
View Related