I am not sure where to place the ONCLICK code in the hyperlink as this
link is written out via response.write......Its all the " " & ' ' that
get me ...
I would like to know how to go about sending a query to a database when a certain image/link is clicked by the user.
By this I mean e.g. table in a database called cd, primary key in table id. Each image/link has its own id number which refers to its record in the table.
So when the user clicks an image or link i would like it to preform a SELECT query using the id number.
How would i go about giving a link/image its own id number? I guess this is simple as i have seen it on many sites and have seen the query string at the bottom of the browser in status bar when you hover over image/link.
My code retrieves a username and a password from a form. Then this information is compared to some usernames and passwords that are stored in a database. The important thing here is that the comparison must be case sensitive meaning that "passWord" is not the same thing as "password"
I have this code, working fine in access 2003
SQL = "SELECT * FROM users WHERE StrComp(username_column,'" & entered_username_in_form & "',0) = 0 AND StrComp(password_column,'" & entered_password_in_form & "',0) = 0"
but get the following error when I run it against my sql 2005 database.
[Microsoft][SQL Native Client][SQL Server]'StrComp' is not a recognized built-in function name.
I don't know the corresponding t-sql for the query.
I am running a querry on an access database and have set the number of records/page displayed at 20. if there are more than 20 records returned, then 1st page will show the first 20, the next page will show next 20 and so on....
The trouble:
the count of total records displayed is correct and the first page is displayed correctly. But when i click on *Next* to go to the next page, all the records of the database get displayed (not the 2nd page of records from the query).
In Access you use "*" + [passed variable] + "*", + can be replaced with & Calling a parameterized query in Access requires % be used in place of *, however, all that I have read show dynamic SQL passed to Access:
WHERE [some column] LIKE '" & ASPvar & "' % ORDER BY ...
However, my call is similar to:
conn.qMyLookup strVar, rs
If I modify the query in Access to:
"%" & [passed variable] & "%"
I get all records. If I only put it at the end, as suggested, I only get matches at the end, not throughout the column. Code:
Does anyone know how to hide and show a link depending on the level of the user. Like I want the link to show if the person loging in is an admin, but if the person is a user than I dont want the link to show?
Having a problem getting my asp url to work. Im trying to pass a var and some of them have the & in them. This is breaking my url since it looks for another var with the &. If i put the %26 instead of the & manually it works fine. How do I get that to encode that on the link ?
I know the problem is the data that is in the heading field has & in them. I can not fix that part. Is there a way to force the & in the url to go to %26 ? Code:
To secure files on a site with authentication we have put the attachments in a folder outside the IIS web site like this:
D:Documents<ItemID>filename.doc
where ItemID is a number which we use to check permissions inside our application.
In order to download the file from the site we have made a binary reader component (we could probably use SAFileUp or something instead, but this works) to send the file through an ASP-file:
http://mysite/Docs/ShowDoc.asp?ID=<ItemID>
This works well.
So to my problem: If I right click the link to save the file on my local computer (Save target as), it will save the file properly, but the filename in the Save As-dialog is ShowDoc.asp. I want it to be filename.doc instead. Is it possible?
I've heard that on a Apache web server you can write the link like this:
http://mysite/something/filename.doc?ID=<ItemID>
but then the server knows that it's http://mysite/Docs/ShowDoc.asp?ID=<ItemID> it should load. If this is possible in IIS, the Save As-problem will be solved.
I have a database of literature and I've created a search page that pulls up the records matching the search criteria. However, I'd like to create a link to the article in pdf format, if it exists. I have a field in the database that contains the file name (and path), but not all records have a corresponding pdf file. Code:
I would like to have a link that when clicked, sends info to an ASP page to process, but does not submit the entire page. This way, the user will click on a link and will not be taken to another page, but precessing will occur. This is mainly for a 'Rating' Application. Amazon.com does this and I want to know how they do it. Here is the link to the amazon page (you may need to be logged in) http://www.amazon.com/exec/obidos/t...5480771-6490552.
(1)I posted this in general but didnt get anywhere. Then I recalled seeing something recently on the web on an ASP site but cannot recall where.
(2)I have a list of pdf files avaiable for the user to view. When they click the pdf link, the pdf file opens. How can I make the link be a 'save' link? ie, when they click the link, windows treats it as a file to 'save as' etc...
What I vaguely recall on the ASP site was: 'How to hide the path of a download file by using an ASP redirect page'. I was wondering if anyone knows this method, and if they do, would it solve my problem in (2)
I would like to put a picture on may page and I would like to use this picture as a button to execute an sql query, so when you clik on the picture you will hace displayed in the next page the product in the data base and other info like price for example. I have this code to access the data base but I do not know how to use a picture s a buton to use it. Code:
and my link is <A href='register.asp?ret_page=<% =request("ret_page") %>
But the ret_page appears as /vfolder/Content.asp?ContentID=700. How would I get rid of the /vfolder/ and just have the content.asp?contentID=700 alone.
I am trying to create a link that takes a record ID and opens up a PDF file that is associated with the record ID in the database. The following code works
If you have a webpage with frames, say a footer frame that contains links, how can you get out of the frame if you click on a link in the footer. The it works now, is if I click on a link, the page loads inside the small footer frame. I'd like it to just get rid of the frames completely when I clickon the link. Any clue?
Example, Firstly go to http://www.koolgift.com/index.asp, Select Products button... Choose "Apparels & Towels, Caps & Hats"... then choose "5 & 7panel caps & winter caps"... when you scroll down, you will see the Back link button.. when u click on it..it actually link you back to the previous page... however i will like to link it back to the page where the list of products under "Apparels & Towels, Caps & Hats" is...
this is my current coding for the Back link <td width="766" valign="middle" align="right"> <a href="#" onClick=javascript:history.back(1)> <p align="right"><font color="#FFFFFF">Back</font></a>
How would you go about creating a link on a desktop through an asp page. You know the old trick click here to bookmark this page?. I need to take that a step further, i need a link that when clicked it creates a link on the desktop to that page.
I want to make a button just like here (when posting new thread) to insert hyperlink into text. For example when user is typing text into textarea I would like to have also a button that can enable users to post different links to other intenet pages. And I would also like to have button that makes the text bold (Actually those are buttons that appear on most forums when posting a new thread)
when you click on it to go to the off site the user name and password will be automaticly inserted to where the offsite is asking for the name and password. My company deals with insurance companies and we would like to make it to where when our employees go to our intranet and click on a link to one of our carriers it will have the name and password in place for them. i heard its possible and old company did it but I am having so much trouble trying to figure this out.
why does this 'file download' box pop up when I click a button on my html page? Saying do I want to open or save the asp file? if I click open it opens it in development.
Could anyone tell me what big corporations do for link management? For my site, whenever I want to change a URL, I don't want to because I know there are 10 pages with that link...
But, right now I'm doing a redesign and will be editing every page, so I thought I'd better find out if there's an efficient way to manage my links...
My first thought was to create a page which I include in every page, and this page has all the links for diff pages, like so:
What I want to do is place a link on my page, and when someone clicks the link a popup appears, and the page they are currently on goes to the next page. e.g
page1.asp contains the link. When a user clicks the link, they are taken to page2.asp. But a popup also appears when the user clicked the link.
What I'm looking for needs to run on Win NT, I prefer an ASP file since I am a bit familiar with that.
I want to have a sidebar links list at the end of the list I want a link that says "add link". When clicked it would bring up a pop up window where you would enter the url and title of the site you want to add.
You would enter the information and it would add the link to the bottom of the sidebar. I've found the script in perl but I wasn't able to get it flying on my site.
If you look at the following url, look on the left where all the links are, at the bottom I want to be able to have "add-a-link" at the bottom. The visitor would be able to put there own links at the bottom and a cookie would remember what they added and put it there when they returned... Code:
Anyone have a clue how can I protect files I'm offering to download? I mean that they will be able to be downloaded only from within my site and not if someone is puting the link to my files in another site/forum .... I can make password protected folders if it helps....anyone got a clue?
oh...and please dont tell me to use htaccess ... it's a windows server and anyway I can't do it...
