I have a page that uses my primary key (id) as a hyperlink for the 'type' field (text) coming from my database..
<%
Dim adoCon
Dim rsProperty
Dim strSQL
Set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("_db_importproperties.mdb")
Set rsProperty = Server.CreateObject("ADODB.Recordset") ......
I have to generate 6 reports based on campaigns of my university..
There is one issue in one report.. In review report, when the user reviews it (means.. user view it by clicking on image associated with that records).. I want to change that image with other image..(i.e. image that shows..records has been reviewed).and so is there hyperlinks.
How i can do for all the records ?
I am trying to find a way to save/copy ASP/HTML generated tables on a webpage as images.
In other words, I want users to right click on a table and save it just like the way they would save an image.
Is there any way of programming this behavior without having the user ro download any software like ActiveX?
Would someone be able to explain the sql image field to me. I was reading about it a little but dont really understand.
I would like to have word documents that can be indexed and searched and i heard the image field with an accompanying char field with the file extension would be the trick. how would i actually get binary files into the image field?
I wanted to write an asp script so users could enter .doc that they could query. I understand basic asp sql inserts.
I have aproblem to transfer a data from table x to table y based on id. Its mean when 2 table have same id all data table x must move to table y. I don't know which command need to use is it insert into or update?
<%
Dim conn
Dim rs
Dim MYSQL,MYSQL2
Set conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
Set cmd = Server.CreateObject("ADODB.Recordset")
conn.ConnectionString = "DSN=prmm;UID=administrator;pwd=sa"
conn.Open
startdate=request("tarikh1")
enddate=request("tarikh2")
MYSQL = "SELECT * FROM table_x where paymentdate between '" & tarikh1 & "' and '" & tarikh2 & "'"
rs.open MYSQL,conn ....
I am trying to display the content of a Table called
'Order Detail' directly from the database (e.g., Northwind.mdb). I have the following commands:
Set tableSet = Server.CreateObject("ADODB.Recordset")
tableSet.Open table_name, DB_name, adOpenForwardOnly, _
adLockOptimistic, adCmdTable
where, table_name = ''Order Detail" Or
table_name = 'Order Detail' Or different variations.
I always get error on the second command with the following message:
Syntax error in query. Incomplete query clause
which I believe because of space in the Table Name. How can I resolve this issue? (working with file or table name with space)?
I've never understood how this works so hopefully someone can shed some light on this. If I wanted to create a hyperlink that would initiate a pop up "Save As" box, would I use JS? And secondly, doesnt anyone have any idea how this would be done. I didnt have any luck finding the answer to this when I googled it. I found one example of how someone was trying a similar technique but wasn't quite the same. The reason for this is Im making a simple webpage so some elderly people that arent computer savy can download some WMA and WAV files from my server. I dont want to explain they have to right click on the link.
View Replies View RelatedI have a client who has had a ASP site with an Access database for several years. It stores information for the used cars on his lot. I have stored text in the database that points to the location of the image for each record. Each record will have a thumb image that is supposed to display in a list of vehicles available then the user can select an item from this list and a new page displays with the information and the regular size image. So far everything has worked fine exept for the display of the images which are stored in a separate directory called veh-photos. All I get are image place holders. I am using Dreamweaver 2004 and and Access 2000 for the database.
Following is the code to list vehicles: ....
1.I want to show a image file of type '.tif' in the browser window; for that I'm writting as ASP code page.
2.This '.tif' type image can be shown better with 'Kodak Image Control'.
3.To have this 'Kodak Image Control' on my code page I just add it's ..ocx to tool box and then drag it from 'Toolbox' to the page.
4.Now after dropping this control to the code it's type is getting changed to 'object' instead of type 'ImgEdit'(and I think this is the
reason I don't get correct result).
5.On one button's 'Onclick' event I'm calling a javascript function with which I'm setting a 'Path'and'Display' property of a control.
6.And want to show a image at location -- '..MFTDRCMF919685173-62.tif' which get shown in new browser window but could not get shown in that particular control. That means the path is correct, then what is the problem?
For better understanding of problem I'm pasting a following code which I've tried up till now......
..................................................
<%@ Language=VBScript %>
<% OPTION EXPLICIT %>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
<SCRIPT LANGUAGE=javascript>
<!--
function showpic()
{
var path;
path = document.frmtif.path.value;
alert(path);
document.frmtif.ImgEdit1.Image =path;
document.frmtif.ImgEdit1.Display;
window.parent.self.open(path);
}
//-->
</script>
</HEAD>
<BODY bgColor=#ffe4e1>
<form name="frmtif">
The Image
<P>
<OBJECT id=ImgEdit1 style="WIDTH: 409px; HEIGHT: 218px" type="ImgEdit"
align=left
border=1 classid=clsid:6D940280-9F11-11CE-83FD-02608C3EC08A
name=imgtif></OBJECT>
<input type="hidden" name="path"
value="..MFTDRCMF919685173-62.tif">
<input type="button" name="show" value="Show" onclick="showpic();">
</P>
</form>
</BODY>
</HTML>
..................................................
I am creating a dynamic ASP VBScript page, which gets data from an Access database.
In the database, there is a field which holds a URL to an image. I can get the image to display fine, but where there is no file that matches the URL (i.e. a missing image) I want to display an alternative, default image (e.g. one that says "Awaiting Image"). The field is never blank, but the image file may not exist for all records in the database.
I think what I am trying to get to is the following:
If file exists (using URL from database to get location of image file) then
display image using the url from the database as the image source
else
display default image - hardcoded in program
endif
I have had a go and come up with the attached but I get an error with my if statement...
I have an Access 2003 database with 1 table that has 2 fields - Date and Description. Both are plain text. This is the basis for a basic calendar displayed as a table using ASP. So far as plain text it works perfectly.
Now I want to generate bolding and hyperlinks on the text in the Description field. Not all fields contain text in the same format, and not all need bold or hyperlinks.
Example: One record will be "Meeting at the Boarding Barn at 1:00" where I want "Boarding Barn" to be a hyperlink. Next record will be "Competition in Milwaukee" where "Competiton" should be bolded, and "Milwaukee" will be the hyperlink. Third record will be "Annual Picnic" and will not have any bold or hyperlink.
I put the HTML tags in the text in the database, but they are ignored. What is the right way to do this?
Rather than doing this:
<A HREF="editpatient.asp?ID=1>View</A>
Can i do something like this instead? - and make it work
<A href="EDITPATIENT.asp?ID=" & LISTBOXPATIENT & ">View</A>
where LISTBOXPATIENT refers to a database populated listbox
The idea being that when the user is completing a form they can look up additional data on a patient by clicking the hyperlink next to the listbox.
How do I write a hyperlink on an asp page to a word doc
not in the web root?If I have a page in my test directory of the web root and
my files are sitting on my e drive?
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.
I make a recordset as hyperlink with the new page, it work fine but my question is. is any way to make that hyperlink inactive when is no data or NULL in the field? Code:
View Replies View RelatedI am writing an intranet and want to be able to hyperlink to all files
within a specific folder AND it's subfolders. Whilst I can hyperlink to the
files in the specified folder AND I can also iterate through the subfolders
and list them, for some reason I cannot hyperlink to the sub folders. I am
writing this software at home using a computer that has IIS and Windows 98
and am accessing this as my server from another computer on my network.
My Home Page on the Server is http://maxitek (the name of my Windows98
Computer) and when I look at the value of the variable "PathSpec" - it
becomes C:Inetpubwwwroot which when I try to create links to the sub
folder it is probably here where the problem is. The files themselves link,
but not with their full subfolder names, i.e., for a file called
"C:Inetpubwwwrootmytestmytest2mytest.txt" I am getting a link that just
looks like this Code:
I have some code that is placing a hyperlink on an ASP page. When I run the asp I get:
<A HREF=" instead of the hyperlink name i want. In addition it does not finish the code below. Can amyone see an issue with my syntax or the code itself.
When I click the hyperlink the corrosponding URL is not right? Code:
I am displaying records from an Access database. One of which is a hyperlink.I was wondering how i get it to open in a new window when the user clicks on it.
code:
Dim strLink
strLink = rs.Fields("Website")
'Website is the field name in database
Response.Write("<a href=" & strLink & ">" )
I have an asp calendar. Nothing complicated really. People enter the data through a form... it writes to a database... and when you click a day it retrieves from the database. The problem is one of the fields is a hyperlink to more information about the event on another website. The text of the link shows but it doesn't actually link.
I have the field in the database set up as hyperlink and not text and I'm pretty sure that the asp code I should be using starts out Response.Write.... I just don't know what to do next... I've tried everything imaginable... below is what I thought it should be but this didn't work.
Response.Write "<a href="Rs("Web_Link")">"
I'm sure I'm missing something painfully obvious.
I have a postscript that prints any given text to a text file.how to make; for example a word like "Test" to a hyperlink.so that it prints a hyperlink in the textfile to be precise.I know i need to make a script that fetches the word and prints the html for the link.but i dont really know where to start.
View Replies View Relatedi got this error:
Error Type:
Microsoft VBScript compilation (0x800A03EE)
Expected ')'
/update.asp, line 46, column 28
Response.write("<P><A HREF="default.asp">Return to Main Menu</A>")
I just want to write a hyperlink in ASP. getting many errors . can anyone please help me with this.
Response.Write("<font size=2 face=arial><A Class=TableLink href = "
link://cs-dev.verizon.com/cs/aa.asp?K=123&srcserver=Cs" & "onMouseOver=" & """" & "window.status='Case';return true" & """" & "onMouseOut=" & """" & "window.status='';return true" & """" & ">Case:</A></font></td>")
I am trying to create a page that contains a recordset and one of the fields to be a hyperlink to a download.I am using an Access database and don't seem to be able to make the hyperlinks 'active'.
View Replies View RelatedWhat is wrong with this code i want to make a hyperlink from the value that comes from Newsletter_Subject: Code:
<%Do While Not ObjRS.EOF %>
datumophaal=<%=FormatDateTime(objRS.Fields("Newsletter_date"),2)%>
<tr valign="top">
<td width="100"><%=datumophaal%></TD>
<td width="100"><%="<A HREF='admin.asp'>ObjRS.Fields("Newsletter_Subject")</A>"%></td>
</tr>
<% ObjRS.MoveNext
Loop
Iv'e been trying to build a ticker that scrolls dynamic text containing hyperlinks. The ticker and the dynamic text are no problem but i'm having trouble trying to hide the hyperlink code from being displayed. Any ideas?
View Replies View Relatedi have a link as seen below in test1.asp page:
<% Response.Write("<a href=http://IP_Address/page1.php?action=send&name=Jimmy&message=hello">Send</a>") %>
When i open the page at local server it's work. however when i open it from client site, it show this error.. Incorrect IP
for your info, the remote server that located page1.php page is only recognised the local server that containing test1.asp page. Is there any solutions for me to solve this problem?
i'm attempting to create a hyperlink of each entry of a certain field which i have in my database (very much similar to the ones created with HTML, where u can click on some highlighted-text that links to another page), but i want the links to appear on the page when it's loaded and each entry has it's own link. Code:
View Replies View RelatedI've been using both Frontpage and Access for a couple of years. Now I'm trying to integrate the two of them.
So, I have a webpage with a map of several locations. I want to be able to click on a location and have it run a query in my Access database to spit out
information about that one site.
My Access database is loaded on the server. I've created an .asp already and I can use the Frontpage interface to select various sites, but I want the query to be driven by what site I click on.
and of course I've already created the hotspots. What SQL coding would I use to tell the Frontpage Database Results wizard to look up information based on which hotspot I clicked on?
Below is the current code which displays the Region Name and what I would like to do is make the Region Name a hyperlink passing a value like the second code listed, but when I try that I get an "Expected ) " error. Code:
If strCurrentRegion<>strLastRegion Then
Response.Write("<tr bgcolor=#D3D3D3><td colwidth=""150""><b>" & strLastRegion & "</b></td>")
Code:
<TD><A href="//amsdb/rollout/RegionResults.asp?RegionID=<%=rs("RegionID")%>"><%=rs("RegionName")%></A> </TD>
I am writing an ASP page that uses the Spreadsheet Office 200o Web Component. I need a cell to open up a popup window when clicked. I can only get a new page to display using hyperlink. I want this to be a popup page like the one you can create using window.open().
Can this be done? Can I do this using some window/Spreadsheet events, can a SpreadSheet cell contain a call to a javascript method? I would like one of the columns to contain not only a hyperlink but also be displayed as an image of type *.gif. Is this doable?
I've been using PHP for some time now and have noticed the big difference between asp and php. In php i have been using this code
<?PHP
if (!isset($_GET['p'])) { // no page specified -> load content from default.txt
include("includes/center.php");
} else { // page specified -> load content from relevant text file
include("./" . $_GET['p'] . ".php");
}
?>
so for example if i clicked on the hyperlink that had this value "index.php?p=member" it will open (preferrably include) the member.php page onto the index.php page. How would this script be written in ASP?
I've got a domain, someDomain.com that I work with in house. There is another domain otherDomain.com that we've contracted to do some work for us.
So, our users log into our web site and a select group of our users get a link to this other site (otherDomain.com) do to some stuff.
I've been requested to have this link on our site do an
"HTTP Get command as a client side redirect (HTTP status-code 3xx, usually 307)", to their site. I'm supposed to pass them a userid and a session 'key'.
How can i do that type of HTTP request with a hyperlink? Doesn't that need to be in a <form></form> with action=GET?
Or...is a simple link like <a href="www.otherDomain.com/somePage.html?User=theUser&Session=theSession">The Link</a> already doing an HTTP Get command? Or yet again...does this do that type of request??: Response.Redirect "www.otherDomain.com/somePage.html?User=theUser&Session=theSession"
How to create hyperlink in order to download files in microsoft access? I have change the field into hyperlink but it only can be downloaded once.
View Replies View Related