Dynamically Alter Hyperlink...
I would like to store a table of alternate URL's it would work like this - in my forums, a user may add a URL (for example www.hyperlink.com). When another user would click on this URL, I would like to call the alternate URL table to see if an entry exists for the domain "hyperlink.com" If so, I would like to alter the hyperlink (on click) to "www.hyperlink.com/123/test.asp" If the URL is not listed in the alternate URL table then I would like it to go to it's original target address.
View Replies
ADVERTISEMENT
How can I dynamically hyperlink using recordset value.
I have an ASP detail page containg values that relates to categories, Geographical location etc. I want my users to be able to click a recordset and be linked to the appropriate pre-defined subset of the records in my SQL Database.
View Replies
View Related
I am trying to change the data type of one of the columns in my SQL table remotely (via ASP scrpit). I understand that ALTER TABLE will allow me to drop and add columns, but I can't find any information on ways to alter the data types.
View Replies
View Related
I want to alter the text displayed in one textbox depending on the value input into another textbox. For example, when entering a customer code into the first box, I want to display the customer name in a second textbox. This will have to be done more than once on a form.
View Replies
View Related
I have a web form that submits data to an email box. I would like it to only send those fields that had input and not the zeros. how to alter my script.
View Replies
View Related
How can I change a column in my database so it becomes auto_increment? Something like,
ALTER TABLE Article
ALTER COLUMN Id autoincrement
View Replies
View Related
if I add <% Server.ScriptTimeout = 300 %> to a page, does that then alter
the default 90 second script timeout for ALL pages (if so, is it for that
session or until??) or does it just alter the timeout for THAT individual
page?I've been through the IIS docs and I haven't been able to find the
definitive answer.
View Replies
View Related
ALTER TABLE Sales ADD COLUMN UnitPrice CURRENCY;
does this command allow for overwriting (or skipping) the column if it already exists? The reason I'm asking is because the file that I'm reading in will contain the column and the value associated with the column.
However, some files may or may not contain certain columns, thus if it doesn't exist I have to create a new one, or I need to add to it.
View Replies
View Related
I have an Access table with some fields set as text and I would like to convert them to integer.
For some reason some values have wrongly been entered with chars, thus
ALTER TABLE my_table ALTER COLUMN my_field Integer
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
If I manually convert the field using Access, I get warned of possible data loss, but the conversion takes place anyway.
How can I force the conversion using just SQL? Is there something like an option "override errors" / "force conversion"?
View Replies
View Related
does anyone know of a free utility that allows you to alter/create tables through the web for access 2000. I'm talking about the table/db structure, not creating records.
View Replies
View Related
cmdTemp.CommandText = "Select * From users"
cmdTemp.CommandType = 1
Set cmdTemp.ActiveConnection = DataConn
rstContacts.Open cmdTemp, , 1, 3
rstContacts.Move CLng(Request("Record"))
i only want this command to display from the users table the details
of the user that has the username (from the database) equal to the username of the person who has just logged in from my login form (uname input box) this code at the moment displays the first record, i dont want that.
View Replies
View Related
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 Related
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?
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
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 Related
I 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:
View Replies
View Related
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:
View Replies
View Related
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 & ">" )
View Replies
View Related
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.
View Replies
View Related
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 Related
i 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>")
View Replies
View Related
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>")
View Replies
View Related
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 Related
What 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
View Replies
View Related
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 Related
i 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?
View Replies
View Related
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 Related
I'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?
View Replies
View Related
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>
View Replies
View Related
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?
View Replies
View Related
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?
View Replies
View Related
