Does anybody know if it is possible with asp to link a txt file to an access database?
Now I have linked the file using Access and uploaded the database back to my webserver, so I have a 'link specification'. I'm not sure how this is called in English since I'm using MS Access in Dutch , but a don't have any idea how to use this specification (where is it stored in Access? to link a txt file to the database.
I have an Access DB which contains couple of link tables. All these tables are from different databases. So each one has it's own database password. Since there is no way to save the password during the DSN creation. Then you need to manually type in the password each first time when open the table.
This causes the problem in ASP code during run a query. Since the table cannot be accessed due to the password protection. Is there any statement than can open a table and meanwhile pass the password in? Does anyone experienced with the similar situation?
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?
Can anyone tell me or guide me (in details) on how to link Access Database in ASP, including SELECT, INSERT, UPDATE, DELETE issues.Is there any sites offering this resource?
View Replies View RelatedOk.. I have a form the user fills out. An email is sent to them and one to our office with a link to the DB so they can view all the info. My form works fine, my emails work fine. The info gets inserted in to the DB fine.
What I would like to do is:
When the link is sent to our office, I would like it so when they click the link it opens the DB right to the info from the link. You know, like when you get an email from here saying someone posted your link has it set so when you click it, it will go right to that post.
So there you have it, any takers.. I sure could use this, otherwise they open the DB and have to search for the info and they do not like having to do much work..
Is it possible to call fields from a MySQL Database and an Access Database on the same asp web page? If so, can someone please point me in the direction of a good guide/article/post on how to do this.
View Replies View RelatedI connected MS Exchange Server to MS Access database using Access link
table function. I can open the database table and see the fields and
data inside the link table. However, the table seems cannot be queried
by SQL statement.
My situation is:
I'm building an intranet. I have a ASP login page for all staff in the
company to login. Other people can't register or login the intranet.
That's the reason I use the company email address to verify username
login name.
After I made the link to the Global Address List (rename to
StaffList), I can see the Alias field. I wrote ASP code to use Alias
field to verify user login name. But, the ASP page seems experiencing
difficulties. I always got the "Connection Timeout" Error. 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?
View Replies View RelatedHow to get a link / url in a var ? This is what I need to do :
newmsg = " <a href="http://www.my-url"?pa=<%=userid%>> Click here </a> "
Clicking url that points to an exe pops up Open/Save dialog box. But I want
only the Open option to be enabled
How display a link like a plain text (not underlined) with css code.
View Replies View RelatedHaving 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:
I would like to build a dynamic link based upon a value returned from a db
There is data in the db because objRS("Description") returns a value.
something like
Code:
if objRS.EOF then
%>
<a href="/somepage.asp?id="<% objRS("Id") %> "><%response.write(objRS("Description"))%></a>
<%
else
end if
I get
http://localhost/somepage.asp?id=
Nothing else at the end.
What am i doing wrong?
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 am using this code
<table border="1">
<%
Do While Not rstSimple.EOF
%>
<tr>
<td><%= rstSimple.Fields("username").Value %></td>
<td><%= rstSimple.Fields("password").Value %></td>
<td><%= rstSimple.Fields("email").Value %></td>
</tr>
<%
rstSimple.MoveNext
Loop
%>
</table>
How can I make the email field a hyper link?
I have the following link:
<A HREF=""Schedule.asp?JobNumber=" & RS("JobNumber") & "&PONumber=" &
RS("PONumber") & """>" & RS("JobNumber") ONCLICK= popup() & "</a>
I want the link to reference a function in the <Script> tag as
follows:
<script>
function popup() {
window.open( "Schedule.asp" , ""
,"top=40,left=40,width=200,height=100" ) ;
}
</script>
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 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:
<td><a href="<%=(rs.Fields.Item("Article").Value)%>"><%=(rs.Fields.Item("Title").Value)%></a></td>
How do I check whether there is a corresponding pdf file before displaying the title with a link?
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:
anyone in here got an idea on how i could transfer a value of a form text to another asp page just by using <a href="">
View Replies View RelatedMy hidden field is
Code:
<input type=hidden name="action" value="login">
<input type=hidden name="ret_page" value="<% =request("ret_page") %>">
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
Response.Write "<a href=""file.asp?ID=" & rs("ID") & """>"
Response.Write rs("File Name") & "</a></td><td>"
I'm trying to rework this code to work a little more easier with Dreamweaver. I would like it to look a little more like this:
"<a href=""file.asp?ID=" & <%=(rsNews.Fields.Item("ID").Value)%> & """>" <%=(rsNews.Fields.Item("File Name").Value) & %>" </a>
I'm receiving a syntax error when I try and run it.
one of my downloadable programs is redundant but there are still a bunch of
links out there that point to the .exe directly ...
how do I redirect the browser to another url when someone requests the .exe
file?
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?
i wrote this:
Code:
response.write "<a href=" & "picture.htm?movie=" & movie & """>"
my variable is
movie="few words like this"
but when i start the page it links only to
Code:
picture.htm?movie=few
and i just dont know why ...
I got a problem on how to link my page.
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:
[vbs]
' For Default.asp
lnkTitle = "view.asp?articleid=" & rsArt("articleid") & ""
' Then using like:
<a href="<%= lnkTitle %>">
[/vbs]
But, I'd like to know maybe of an easier or more efficient way... If anything is database related, I use mySQL on a Win 2000 machine.
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.