Retrieving Data From Database - Query String?
I have this page with photo thumbnails that are clickable. Each photo has corresponding info saved on a database. When the thumbnail is click, im trying to show the data in an asp page called info.asp.
sample:
Photo #1 when clicked goes to: info.asp?no=1
Photo #2 when clicked goes to: info.asp?no=2
so on so forth..
the database fields are:
no
picname
date
details
I only know how to display ALL info from a database.
But i cant figure out how to display SPECIFIC info triggered by a query string. Example. Photo #1 is clicked. I only want the data that corresponds to Photo 1 to be displayed. How can i do this?
View Replies
ADVERTISEMENT
I am submitting data to a database field, and the data is being submitted in the following manner to a table in the database:
5,3,4,4,3,3,4,5,4,5,5
It's all comma delimeted. Now, what I would like to do is have an update page in which a user can update these values. I am trying to place the values in a repeated text box that corresponds with a repeated question.
The questions that I am displaying are in a repeated field and each question has a text box that will hold the value that corresponds to. I would like to be able to bring in each value into a repeated text box. Right now, each repeated text box contains the above information. (5,3,4,4,3,3,4,5,4,5,5). Is this possible?
View Replies
View Related
I have a search set up on my site to compare between two <select> values and the value in the data base, but not sure if I have the sql statment correct, my search returns all rows from the table, I want specific row that is between one form select and another... ie. below
for this particular example I want to know if the database AD_PRICE field is between <select name=price> and <select name=price1> and if so, return the only those rows, currently all rows are being returned... Code:
View Replies
View Related
does any one just help me with the an example of retrieving data from access data base?
View Replies
View Related
is there anyway of retrieving the whole name from a file input rather than just the file name.I need to know which directory the file is located.
View Replies
View Related
from the client side is possible to create a XMLHTTPREQUEST object to retrieve data ( in async way ) from web services, or simple from a asp page like this :
----- myasp.asp -----
<% response.write("<info>hello</info>") %>
----------------------
how can i accomplish this, but from the server side using ASP and ASP.Net ?
View Replies
View Related
I've created asp reports getting datas from Oracle. The server im using is 8i while client is 9i. Does Asp support oracle 9i. I mean while retrieving numeric datas from oracle it displays only 0. But if the same query is run in oracle to test it, it displays properly.
Do I have to download any patch or driver where IIS is compatible with oracle 9i. Any ideas whats wrong. Did u guyz understand what im trying to say. For ur better understanding Im sending a doc attachment.
View Replies
View Related
if there is two tables. for example
Table 1: IC No, Name
Table 2: IC, No, Address
IC No are primary keys
There will be only one user maintaining the Table 1 then another user maintaining address only in table 2. So the second user need to retrieve the data from table 1 on the IC No. how should i do it? is it using session?
View Replies
View Related
Is there a way in asp to retrieve part of the URL and use it
say the url was
http://localhost/site/craig/default.asp
or
http://localhost/site/craig/test.asp
or
http://localhost/site/craig/roger.asp?dan=1
is there anyway of retrieving the word craig so to use it in the page, I just want the word Craig
This is because i could have other addresses that are for example
http://localhost/site/jon/default.asp
or
http://localhost/site/jon/test.asp
or
http://localhost/site/jon/roger.asp
where i need to retrieve the word jon
at the moment i use the code
strURL = Replace(Request.ServerVariables("URL"), "/default.asp", "")
intStart = instrRev(strURL, "/") + 1
strName = mid(strURL, intStart)
this worked fine until new pages are added ie a page that isnt default.asp
Obviously i cant use strURL = Replace(Request.ServerVariables("URL"), "/default.asp", "") because default.asp will change...
View Replies
View Related
I have a database with many tables. I have many objects on my form, textboxes, checkboxes etc... I need to populate a second drop down box after selecting the first drop down box with out the user clicking a button, Yes Master I know how to do the JavaScript onchange but every thin I have looked at uses hard coded data in their example. Can you give me a form example using you tutorial DB of multiple DD Boxes.
View Replies
View Related
I'm trying to retrieve information from a field in a database, which contains data, some of which are the same. ex:
let's say the table is called "Person_info" and there are 5 rows of info with a different person's info.
let's say i want to display the info in the fields called "City" but there are duplicates ex:
Toronto
Vancouver
Toronto
New York
Atlanta
I'd like it to display all the cities in there on a web page, but, I don't want it to display the same city twice:
so it'll display this:
Toronto
Vancouver
New York
Atlanta
I just can't get it to work? it keeps displaying duplicates.
View Replies
View Related
I am trying to write a web application that can retrieve information from an access database, store it in a recordset, update it, then update the access database. However, when I try to update the recordset, I get an error (500).
I have checked my field names a million times (so I am pretty sure it isn't a spelling mistake or anything like that), but nothing is working. I included my code so you can take a look at it. Code:
View Replies
View Related
Just wondering. I am developing a blog. I would like to display the message post on the blog to be limited to, say, 100 words rather than the whole message itself as this will increase the page length.
I would like to know if there is a method to count the words from the record in database and display only 100 hundred words from the actual message..
View Replies
View Related
I am currently working on a document management system for my company's Marketing department. They wish to be able to upload files to the server.
Rather than deal with the many permissions issues we have had in the past with saving and deleting these files to the server's file system, this time we are trying to use SQL server BLOB fields to store the files.
The premise is simple -- a user clicks on the link and the file is then shown in the browser. The documents are mostly word, Quark, and Adobe Illustrator documents. I was thinking the code would go something like this: Code:
View Replies
View Related
I have sucessfully installed IIS 5.1 on XP Pro, and have validated a couple of test .asp pages.
When I try to connect to Access through Front Page, i get the following error:
The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.
View Replies
View Related
I am using a Replace function to replace single quotes with double when
submitting a text field in the database i.e. Replace (q, "'", "' ' ")
which works fine. When I retrieve the field from the database which has
apostrophe I am getting 'Object expected' error message. Is there a
way to fix this?
View Replies
View Related
I have about 26 checkboxes that place all of my contacts into categories so in my database for contacts i have a field called categories that contains all of the categeories that each contact belongs to seperated by a ",". 1,5,17 etc.
I need help getting these values out of the database so that when I user select category 17 they get all of the contacts that containg the 17 in their respective categories field.
View Replies
View Related
I want to seach though the drives i.e c or d drives and find for the folders and subfolders and even the files and by that order only it should be inserted into the database.I am using MSACCESS database.
View Replies
View Related
I am trying to search for clients contained within a database using multiple search criteria that the user is able to select using a front end form.
The user is able to select there criteria by selecting one or more check boxes and the results are thus retrieved based on what the user has selected. The search works fine until you try and select multiple client types Code:
View Replies
View Related
Here is the SQL Query string that gives me an error.
mySQL = "SELECT * From tblSuperQ Where (DCR Between '"&DCRF&"' And '"&DCRT&"') And Where (Inductance Between '"&indf&"' And '"&indt&"')"
Can you not combine Wheres together?..
If I use UNION ALL between the two where queries, it returns all the results between DCRF and DCRT, AND all the results between indf and indt. I want it to query only those that have values only in both where queries.
View Replies
View Related
This is a pretty basic question which I've been unable to find an answer for from searching Google - I'm trying to query my msql database to return all news stories where the field "smonth" is equal to January, and "syear" is equal to 2004.
<%Response.write "<a href='news_detail_monthstest.asp?smonth=January&syear=2004'>"%>
and on my news detail page, the query is:
SQL_query = "SELECT * FROM tblpages WHERE smonth=" & Request.QueryString("smonth") & "& syear=" & Request.QueryString("syear") & ""
This returns the error:
Unknown column 'January' in 'where clause'
so it's seeing the value I want to pass and assuming it's the column name, instead of the column name "smonth". The fields in the d/b all exist and are named correctly.
I've obviously made a mistake in my select statement or my query string but I'm not sure what.
View Replies
View Related
I have small problem with query string on Internet explorer 7 since I updated and I saw that problem with other browsers before. My code to search is :
<input name="client_id" type="text" class="style34" id="client_id2" style="background-color: #DCFCE1;padding: 3px;border-left: #A0A0A0 1px solid;border-bottom: #A0A0A0 1px solid;border-right: #A0A0A0 1px solid;" size="30">
</span><span class="style47">
<INPUT name="fillButton" type=image class=noneInput onClick="javascript:location.href('contacts.asp?cid='+clien t_id.value);" value=submit src="images/but_search.gif" align="bottom" width=22 height=21>
But I cant push the button it does not work, what's wrong with it ??
View Replies
View Related
I'm getting a QueryString on a page. From this query string, I need to query a database, get a bunch of file names, attach them to an e-mail and fire it out (no problem). The problem is, I want it to happen when a user clicks a button.
I've been using .NET for so long (this isn't a problem at all in .NET obviously)...that I've forgotten how to handle this. Am I going to need a second page to post an array of the file names to and then handle it there? It just seems awfully redundant to need a second page to handle all of this, but I guess it wouldn't shock me.
View Replies
View Related
I know how to use [field LIKE '%keyword%'] to pull up all records that contains the keyword, but what about not containing the keyword? I've tried NOT LIKE but i get
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
View Replies
View Related
I have heard about a piece of software that can be installed on your server convert unfriendly search engine ASP query strings to friendly strings that search engines can read
EG Before
www.mysite.com/defualt.asp?productID=98283?etc...
EG After
www.mysite.com/product/ID/default.asp
It basically takes the question amarks and weird characters out and replaces them?
Does anyone know where i can get ths peiece of software or what has to be done on my server?
someone please help me :S
Chris
View Replies
View Related
In asp how How can i pass a parameter value with a space in the value like this:
test.asp?catalog=aValue&lineitem=ladies cloths
I get a %20 as a space in the browser window,
View Replies
View Related
I'm trying to encrypt query strings.
For Example...
I want this...
http://whatever.com/?clientID=5
to be something like this...
http://whatever.com/?[encrypted string]
I've seen the 4guysrfromrolla's version. Its fine "but" I don't know
if it would be practical in this case. I would need to encrypt many
urls on a single page and every link on a displayed page would be
pulled from a database. the "rolla" version I came across requires
that a text file be created and key written for each encoded string
everytime the page is called. This doesn't seem that practical to me
because I would be writing files and keys dozens of times everytime the
page is called.I've also seen aspEncrypt but they want 250 bucks and I was hoping to
avoid this. I also see that .Net has a method for this but I'm only
working with classic at this point.
View Replies
View Related
I want to pass a querystring in two files using frameset. I'm using Frameset. I'm using this query string. MY question is this can we pass a single value to (2 different files,) using querystring? Code:
<%
response.Write("<a href=""grid1.asp?strID="&rs.Fields("alphabit")&""" target = ""grid1""grid2.asp?strID="&rs.fields("alphabit")&""" target = ""grid2"">"& a &"</a>")
%>
It only show the value of rs.fields("alphabit") in grid1.asp and nothing show in grid2.asp
Actually I'm using "FrameSet". I just want to pass this value in two frames(in two files).
In short i want to get the value of rs.fields("alphabit"). in 2 Frames.
View Replies
View Related
I am working on a site to provide displaying and navigation of images from
several groups and have the following code that changes to displayed gif
based on the query string passed in:
Call: <a href="ShowImage.asp?group=01&image=01&max=28">Group 01, Image 04,
Max 28</a> Code:
View Replies
View Related
i have designed a website that is using an asp shopping cart script and has a flash header which i have designed to display different content depending on the query string that gets passed to it in the page url. now my problem is that my script has a lot of pages and there are many ways of going from one page to another.
what i im wondering is if ther is away that i can make an asp page directly append a query string to the url when the server generates the page and sends it to the browser.
So basically if say i had a page called home.asp when i opened this page a some code in the page make the page serve as home.asp?page=home&content=logo which would make my flash script display content according to the query string it has received.
View Replies
View Related
I have a search page with 7 different field options to search upon. The user
can use any or all options. On the results page I'd like to put at the top
of each column and ASC and DESC link to resort the results in the user's
choice.
How do I save that original query string to reuse in the sort links?
My results could spread across many pages, so I'm guessing that I would have
to query the database again for each sort.
View Replies
View Related
I have encrypted query values to pass from page to page.I then decrypt them on the other side.On one such pass I use the value to select all the records that match.
encrypted value:
/results.asp?club=!#@(yT5$$
decrypted value:
club=Wildcats
The encryption/decryption works great but when I try to select on the decrypted club=Wildcats the select statement pulls the encrypted value club=!#@(yT5$$ and therefore returns empty query results.
fp_sQry="SELECT * FROM Results WHERE (Club = '::Club::') "
How can I pass the decrypted value through the select stmt?
View Replies
View Related
When using the QueryString of the request object the actual values are exposed to the viewer of the site and often user pickup on these values and start changing them . This can lead user to see data that they are not supposed to or even data that may be erroneous.
Is there an easy way to encrypt the querystring values that get displayed on the location bar / other than not using querystring. Can I use java script to disable the status bar, at the bottom of the page to not expose the URL's of various links on a page?
View Replies
View Related
