i'm using the following code to output the contents of a database:
VALUE="<%=fldThis.Value%>"
which works fine on all of my fields expect for the first which is called "Title" this field contains HTML code so that when displayed or queried by asp it should display as a link.
However, the title field displays the data as follows inside the text box: <ahref= (then a massive gap) then after the text box I have the link title text which is just after the close tag for the link followed by the close quotation marks and close tag as follows:
text box denoted by square brackets: [<a href= blank space] link title">
I am presuming that the code isn't liking the quotation marks for the link.
I have a blog online and I'm wanting to make an ASP page on my computer to just input the title of the daily update and the "entry" I'm making. So I'm developing a form page so that when I submit the information from it, it goes into a page that shows the HTML so all I have to do is copy and paste. Question is when for instance I'm typing in my "entry for the day" and I have a break I need it to automatically put in a <p> or <br> for me
I have a script which stores an image to the server whilst at the same time stores the filename for the image in a database. I am now trying to output the image file contained on the server using the filename contained in the database.
Whilst I can retrieve the filename from the database and also obtain the correct filepath of the image, the image itself doesn't display on the screen!
I need to show some results from a database on a page and also give the user the option of downloading these specific results as a excel spreadsheet ....
I've just been starting to learn ASP and I have a question about wether or not this is the best route to go. I design websites, and I'm doing one right now that is dynamic (usually I design semi-static sites) in the sense that this company is always starting new houses to build. They want to have on their main page a little box that says something along the lines of:
Current Homes: House #1 w/ other info House #2 w/ other info House #3 w/ other info Current Duplexes: Duplex #1 w/ other info etc...
I want the website to grab the latest 3 houses from each category and show them on the site in their respective category. I'm assuming (almost positive) that this SHOULD be done using a database in some way.
Now I'm on the move a lot, and I want this 'data' to be online-accessible, meaning I can add new houses to it just by going to a little secret 'control panel' and simply filling in the information. Should I do this using ASP w/ Databases or some other language?
I've been trying to make my db web applications to work in my test server and I keep getting this everytime I try to modidy the database:
Microsoft JET Database Engine error '80004005' Operation must use an updateable query.
The curious thing is that in my web hosting provider's space it works perfectly. I don't know what's wrong with the configuration of my IIS. Any ideas?
I look at this document (nonsense): http://support.microsoft.com/default.aspx?scid=kb;en- us;q175168
I have created a page that pulls up my data from an access database. A value has a link that goes to a detail page that I want to show all of the information for that value that was clicked.
How do I pass that value and then pull up the information for that value? Do I need to give you my code?
Is it possible to link forms developed using Access 2K with an asp page? I want to be able to pass on the order no. by clicking to an access form and display results.
Is it possible? If yes, can you give me some leads how to do?
I have a submit form with 2 fields: Product Code and Quantity.
I have dynamic table beside my form that displays a catalogue and one of the fields on the table is product code.
What I want to do is to make the Product Code on the dynamic table a link that ONCLICK inputs that code to the form. There is something similar in another post but not for a list coming from a DB. Any ideas, samples ? I'm using Classic ASP, DWMX 2004, windows.
I have a form that has the option to upload a file at the bottom. If you select a file it works fine but if you leave file selection blank the forms bombs. This is not how I want it to work. On the form you need to use ENCTYPE="multipart/form-data" in the form tag.
On the processing page I need to use Set to assign a variable to the form data. I tried using IF on the variable assigned to the file path but it bombs out telling me "This function is not supported". Is there any other way I can check to see if curQes has a value assigned to it?
I have some ASP server-side code that works perfectly when the client is running on Windows (IE, Netscape, Firefox, etc.) but doesn't work at all when the client is running on Macintosh (IE, Omniweb, Safari, etc.) This is the client-side Javascript code:
I have a series a forms that submit data to different tables in a database. As it stands, when a user completes FORM 1 and clicks the SUBMIT button, the FORM 1 data is submitted (action = form2.asp, method = post) to ASP code at the top of FORM 2 (request.form("form1 field name") etc...), and submitted to the database with SQL code, also at the top of FORM 2(INSERT into...). Hence the submit button on FORM 1 directs the user to FORM 2, and submits the data which is exaclty what I wanted. However, I now need the users to submit multiple sets of data with FORM 1, and direct them to FORM 2 once they have finished using FORM 1. Most importantly, I need to pass a few parameters from FORM 1 to FORM 2, and have these parameters submitted to the database.
My main problem is getting a fresh form1 after submiting the same form1, in preparation for anoter set of data using the same form. Basically, the database has 'one to many' relationship tables. Form1 and form2 are both populating the 'many' tables, so that each form needs to be filled-in several times while retaining the key field of the 'one' table. At the moment submiting form1 takes me to form2. Is is possible to submit the data to the database, get form1 back again to submit more data, as many times as required, then click another button to load form2 when the user is finished with form1?
Can anyone please give me some pointers? or at least explain the concept of what I need to do. I am a novice and it's taking me a while to get to this stage. Any help will be greatly appreciated.
Is it possible to post FORM1 to itself and insert the data (i.e. place the request.form at the top of FORM 1) If so, how do I direct users to FORM 2 while retaining my parameters?
I like to know how to write this specifc function on ASP where the user eg: display a set of records on the webpage. Example the data are ID, Name and address.
Lets say i display the data on the webpage and i set the Name as the <a href>. So when i click on the name, it will move to another page with the id of the specific name. Code:
I am a new programmer seeking a right way for transferring data between forum to forum, as i am creating a site wich have a page keeping 20's of server controls like drop down list and text boxes the value of ddl2 changging on change of ddl1 and displaying its corresponding value in text box and i have 10 rows in this way and i wanna display all selected values of server controls in next page as report.
I am trying to create a form where the user can check a box within a form and the address will fill in automatically from a previous address in the form, without submitting the form.
The common solution of this problem is to set the MODE of opening the database to 3, and to call the Host and tell him:-"I need to write in the database, with JET", so he gives to the entire directory the write permission. Code:
I need to get some Request value from a Form... but this form is enctype="multipart/form-data" (to upload files) and I if I use the standard syntax Request("nameField") I don't get any value.
I have a form which dynamically loads questions and answers depending on dept. So the form input type has a value field of the actual answer text which is pulled from the database. Sometimes the form can be 5 questions, sometimes more and sometimes less. So after the user submits the form, I gather the static input (ie. name, address, email, etc..) but 1. how do I loop to Request.Form for the dynamically generated answers if I dont know how many there may be? 2. How do I then take that data and use it in my Insert statement? The questions with each answer will automatically generate the imput name field with the qid (question ID) which could be 1-?
i have this page that inserts a form data into database... the problem is that it wouldn't let me insert my content into the database because of syntax problem... more specifically if i have an apostrophe.. it wouldn't let me insert due to the restriction of my code... is there a way to rewrite my code below so that i can insert apostrophe.. right now if there are ' in my content the strSql will screw up...
Does anyone know of anything or any issues that may cause HTML form box (shopping cart) to reset or not keep its posted value?
out of approx 2000 users, only 15 are having this issue and the common thing between them is using Mac's (Different browsers but mostly IE5 and Safari. even made one install latest firefox) instead of PCs.
Now I know this goes against everything I ever knew about SERVER SIDE SCRIPTING, but im really reaching for straws.
I am developing a program now. This program has a front page for user to select a project. After the user hit "submit" bttion, he will go to another page which has a top menu.
User can see different part of project information by clicking there. I hope no matter in which order the user click on the items in the top menu, it will show the record based on this project until he select a different project. To realize this function, should I use cookies, or there are better ways to do that? It will be very helpful if someone can provide some sample code here.
If Request.Form("Name") = "" Then Response.Redirect "error.asp" End if
If the browser does a GET against this page, sometimes the Response.Redirect doesn't happen. It is as if there is form data being sent on a GET. Has anyone seen this before?
i am working my site using asp html vb javascript and css.
When a user registers on my site i would like them have their own page. I was wondering how would i be able to have a page made automaticaly after that person is registered? I am very new to javascript so....
This is the page after the user is done filling out the form: Code:
I'm trying to retrieve the data off a form (survey.htm) and email the results back to me using CDO and ASP (survey.asp). I'm confused as to how to retrieve the form data from survey.htm and send it using survey.asp. Below is a sample ASP script that I found on ASPFAQ.com and it works fine, but now how do I grab the info from a form and incorporate it into the emal. Code:
I need to select the data where the data ID is equal to the variable supplied in the submitted form. Below is the line of code I used for the radio select and the code to do the SQL search on it. I get the following error using this code:
Error Type: Microsoft JET Database Engine (0x80040E10) No value given for one or more required parameters. /MyWeb/CheckIn.asp, line 93
Dim junk junk=request.form("CheckIn") 'If Session("UserType") = "User" Or Session("UserType") = "Admin" Then Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("db1.mdb") Set rs=Server.CreateObject("ADODB.recordset") 'in below, WHERE id = Request.Form("CheckIn") SQL = "SELECT * FROM CompsIn WHERE ID = junk" rs.OPEN SQL, Conn, 3, 3
I am pulling in data from a sql table. For some reason, when I include the following line:
<tr><td><b><%if rs("Street_dir")<> "" then response.write rs("Street_dir") & " " end if%> <%=rs("Street_num")%> <%=rs("Street_name")%> <%=rs("Street_suf fix")%></b></td></tr>
then the following line does not display:
<tr><td><%=rs("remarks")%></td></tr>
The REMARKS data is blank. But, if I remove the upper address line, then the REMARKS appears. The address is 1111 Main so that does not seem to be the issue. The address information is VARCHAR fields, 255 characters.
This works fine on another server where my files used to be, but I just moved to a new server.
Is it possible if i wanna append xml data and upload picture at a same time using the same form?
The problem i'm facing now is, when i add the 'multipart/form-data', i can't append the xml data
I know there's one solution, using 2 FORM but the project i'm doing now is designed to be put them both (file type for upload and textarea for append) together
Besides, i have no idea how to encode or decode the posted data.
This isn't actually causing a problem, but it's odd. I am getting additional data in the data posted by a form on a particular search script I have. I didn't even notice it (since it wasn't causing a problem) but I outputted the form data to screen just out of curiosity I found the following attached to the end of some data: §or=ANY
