Creating A Link For The URL That Is Inside Record Set
How can i make the URL to be a link that is in record set (coming from the database)? Along with URL this field might alo contain some text message.
View RepliesHow can i make the URL to be a link that is in record set (coming from the database)? Along with URL this field might alo contain some text message.
View RepliesI've created an address book, and each user's record has a few fields that hold their website URLs. Each time I query the database for a record, I save the URLs as string variables... website1, website2, and website3. In the webpage to view each member's profile, I code their websites like so:
<a href='<% =website1 %>' target=_blank><% =website1 %></a>
The problem is that the domain where I host the page gets appended to the front of the string. So if a user enters something like me.blogspot.com as their webpage, it actually links to "http://www.mydomain.com/myrootfolder/me.blogspot.com/" when it's supposed to just link to "http://me.blogspot.com"
Is there a sure-fire way to solve this problem?
how can i create a NEXT, PREVIOUS record navigation link; such that when i retrieve from the database and click NEXT it will display the next set of records, or when i click on PREVIUOS, it will display previous set of records from the database.
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..
I'm building a simple image gallery. When I upload the photos, they all have the same filename except for an incremental number. For example:
photo_of_event_1.jpg
photo_of_event_2.jpg
photo_of_event_3.jpg
photo_of_event_4.jpg
I have a SQL table where enter in the filename "suffix" ("photo_of_event_") and then I enter a start number (1) and an ending number (4).
So, each gallery only has one record entry.
Now, I need some advise on how to take this record and generate a page that displays all three photos.
Is there a SQL statement that would generate an incrimental list of number (1,2,3,4 in this example?).
I am trying to creating a function to find a record that was entered in a database. I have created the add button with no problem and it works. The links are:
Text file
ASP file
When I placed the script in the code (lines #524 - #547), I now get an error message looking for an "end" statement. Before this everything worked fine. If I have and "else" statement after closing the form and and "else" statement after opening the recordset, I don't understand where I need the "end statement."
I'm getting this error message: Error Type:
Microsoft JET Database Engine (0x80004005)
You cannot add or change a record because a related record is required in table 'employees'. Code:
I have a front end with all the code and a backend with some tables. Want to convert this into website database. Most probably convert the frontend into ASP. Is this the only way? Can one use the VBA code inside ASP with translating the VBA into ASP?
View Replies View RelatedI need to do a loop with some criterias that depends on an earlier database
query. I tried to do it this way, but it seems not to accept that the do
is inside the if:
if not objrs.EOF then
Do until updatearray(0) < objrs("updated")
else
Do While not fso.AtEndOfStream
end if
Blabla my repeating script here...
Loop
I'm getting this error:
Microsoft VBScript compilation error '800a03fb'
Expected 'Loop'
/x.asp, line 46
else
^
It seems somehow that the do is "stronger" than the if statement, as it didn't
even help doing it this way: Code:
I've inherited webmaster duties for a website done in ASP.NET. After much trial and error I've figured out the architecture of the site, and have a template for the area of the page that contains the content. I need to pop in a dropdown menu, nothing fancy, like the one on this Post New Thread page for "Category".
Does anyone know where I can get the syntax for one? Or does someone know ASP.NET and can write out a simple dropdown menu code for me?
I've put a div red with some text inside a TD, but its height is less than 100% of TD height as you can see.
I've defined the following styles:
div.test { background-color:red; height:100%; width: 100%; }
table.test { border: 1px solid #CCCCCC; background-color:yellow; }
td.test { border: 1px solid #CCCCCC; }
does anyone know a solution ? Code:
I see that you can have HTML code inside an asp file.
Can you have php code inside an asp file
I need to make a search to search our database that can be put on different customers websites. So I was planning on making the search a reusable asp.net control. But a lot of our customers websites are written is ASP. So Is it possible to call an asp.net control inside an asp page?
View Replies View Relatedis it possible to do a for loop inside of a Do while not.
View Replies View RelatedI have an insert record form that posts fine to a db which automatically creates an ID how could I get the next page to do a preview using the ID just created by the DB to go to the right record?
View Replies View RelatedI have a .asp page which lists a date, then a bunch of record lines for data that falls within that date, then the next date and it's bunch of data record lines. e.g.
Ship Date: 04/06/04
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Ship Date: 11/07/04
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
What I want is:
Ship Date: 04/06/04
1: Data xxxxxxxxxxxxxxxxxxxxx
2: Data xxxxxxxxxxxxxxxxxxxxx
3: Data xxxxxxxxxxxxxxxxxxxxx
4: Data xxxxxxxxxxxxxxxxxxxxx
Ship Date: 11/07/04
1: Data xxxxxxxxxxxxxxxxxxxxx
2: Data xxxxxxxxxxxxxxxxxxxxx
3: Data xxxxxxxxxxxxxxxxxxxxx
How can I get these numbers printed againsts the records ?
Is it common practice to create a recordset object inside of a loop? Does it create multiple connections to the database?
View Replies View RelatedI have a form which consists of Iframe
<Form method="pst" action="test.asp">
<iframe src="testingframe.asp" id="testfram" frameborder="1"
scroll="auto">
</iframe>
</Form>
testingframe.asp has
<table>
<td>
<tr>
<input type=checkbox id="checkedName" name="checkedName"/>
</tr>
</td>
</table>
How do i acess checkedName value in my main form .... ?
is it possible to put an ASP function inside the javascript function?
e.g.
<script language=javascript>
function sample()
{
<%
here goes the asp code
%>
}
</script>
We need to display certain websites inside a frame on our website and I use the response.redirect command in VBScript.
The problem is that some websites take over the whole browser, how can I stop this and force a website to be loaded inside a frame?
Could anyone tell me how to select the first three characters in a string, then put inside into another string.
View Replies View RelatedI need to write a search function which should be able to search text within PDF documents and (if possible) creat a link to that document / page .
View Replies View RelatedHaving an issue trying to access a variable that is populated by a value inside a recordset that I want to use in another statement. I've included the source code below:
" Do While Not objRSZone.EOF
strSuburb = objRSZone("suburb")
strZone = objRSZone("zone")
strPostCode = objRSZone("postcode")
If frmSuburb = strSuburb Then
Response.Write "Zone for " & strSuburb & " = " & strZone & " , Postcode = " & strPostCode & "<br>"
strShipZone = strZone
Response.Write strShipZone
End If
objRSZone.MoveNext
Loop "
So what I want is to use the strShipZone variable somewhere other than this place above. But it doesnt work, as it is on the loop, if i put it outside the loop it is populated by a wrong value.
How can I send messages to user like messageBox from a ASP page without doing postback over the page.
View Replies View RelatedHow do you put an asp code inside an html tag?
This is not working:
<a href="contact.asp?subject=Question about group
<%=(Recordset1.Fields.Item("group_name").Value)%>">Send a message</a>
I am actually putting above info in an Access field. People would be able to send me email through a form in contact.asp and I want the subject line reflect which page they came from.
Was thinking of having an array inside a asp page. I'm rather new to this.How do I begin. my asp page should work as follows.One html page include mail adresses. We receive a lot of junk mail and I was thinking of how to avoid this. Was thinking of creating a asp page with an inout string inside the asp page. The input number should refer to the users mail adress.
We are only four people in our office, so that should be simple to manage.The html code should be like "redirect.asp?" for the first mail adress. and redirect.asp?What's the syntax inside the asp page?
I'm currently new to OO programming with Classic ASP and have been stopped dead in my tracks on the issue of validation inside classes and if I should be doing things that way. I have been using a User class and it has methods such as Save(), Update() and Delete(). Particularly with the Update() method I'm unsure if I should be validating my form(s) within the class or on the actual edit.asp page that uses the Update() method?
I have two types of edit pages; one for Admin users and one for the My Account page. On the My Account page if the user wants to change their password they have to enter their current password, a new password and then their new password again to confirm .
If an Admin user is updating that same user's info they do not have to go through those steps and they can simple just change the password by typing it in. The point here is that there are two separate cases of validation rules on two separate pages that both use the Update() method. Do you validate your forms inside your classes or outside?
how I can get a semicolon inside a string? So far, when I've tried to put a semicolon inside a string, I've gotten this error:
Quote: /Default.asp, line 39
Response.Write("<h4 class=""news_headline""><a href=""news.asp?fileindex=" & arrayLine(i) & ""&;mon=" & lCase(Left(MonthName(month(date)), 3)) & year(date) & """>")
I'm still learning .Net and have an ASP.Net app that I'm working on. On this particular page, I need to put a bunch of checkboxes on the side of the page, and the text for each is derived from the database. So I can't just hardcode the checkboxes. I'll have any number of them, and possibly even 0.
I am told that you use a Repeater control for this, but beyond that, am not sure what to do. Can someone show me?
i am unable to figure out some way....so pls if anyone has implemented then do suggest me. i need to have a link on clickign to which i want excel workbook to open (a previously created template) below the link in the form.
how can i do it. i find lot of info on opening excel as an application freshly. i want to
open in the form itself. is it feasible or i am just wasting my time searching info for it.
I've written a script which is still trying to concated couple of messages then send an email. Those messages are a reuqest objects coming from another form as demonstrated below: Code:
View Replies View RelatedThere are two table in my Access database e.g. people and orders. There is a one-to-many relationship between these. At the moment I get a recordset of all the people. I put the results of this into an array (using GetRows) and close the array and set it to Nothing.
Then on the page I have a loop which goes through the array of people and for each one performs a different db search of all the order linked to that person. On the page I have got it displaying the people perfectly but for each search the RecordCount is coming out as -1. Yet, I know there are orders associated with each person.
I'm trying to use a variable like a file and I do not know if it is possible, like this:
varfunc=chr(60)&chr(37)&"function addone(varint) : addone = varint + 1: End function"&chr(37)&chr(62)
Now I have a addone function inside varfunc.
The value of varfunc is <%function addone(varint) : addone = varint + 1: End function%>
Is it possible I use varfunc like a file or something to make the function active? There are some operator like a pointer to variable or somehow to eval like a code block?