I saw creole's post regarding a similar CF function and thought I'd start a similar ASP thread. If I have an article (entirety of kept in a field adequately named "article") how would I select only the first, say 450 words, to be displayed on a page....followed by a prev/next nav item. Naturally, page 2 would pick up where it left off. How to do this? Or do I have to split the article up into article_sec1, article_sec2, etc?
View RepliesI need to display only a portion (like the first 100 characters) of a field in a database. I don't recall how to do this.
View Replies View RelatedThis script works, however when I read in the fields, if they have a space in them, it only puts the first word in. For example, if the company name is Bell Mobility then it will only put Bell. Code:
View Replies View RelatedI know how to display a text field from an mdb file. You type: <%= CmdPopulateStates("fieldname") %>
where CmdPopulateStates is declared as:
Set CmdPopulateStates = Server.CreateObject("ADODB.Recordset")
But if 'fieldname' was a memo field rather than text field then the information isn't displayed. In fact, if it's anything other than text then it won't be displayed. How do I display other field types?
I am trying to display only certain columns from a table and this is a code that I am using but it is not diplaying anything, can anyone tell me where my code is wrong
<%FOR EACH field IN rstSite1.FIELDS
if field.name ="EmpName" then
RESPONSE.WRITE("<TH ALIGN='LEFT' BGCOLOR='#B0C4DE'>"& FIELD.NAME & "</TH>")
end if
NEXT%>
I have an Oracle database which has a field LONG RAW type to store text files. I'm trying to display the output of this field in ASP but I'm having problems. I've gone through many different approaches but they either do nothing or do the following;
I've tried doing response.binarywrite(rs("data_object")) and I get
somethinglike below ....
I'm trying to write a web form that will allow users update info from a database table. Everything is working fine, except the display of the one text field from the database (nothing displays. Here's what I'm trying:Code:
<textarea name="AdditionalInformation" cols="32" rows="10" wrap="VIRTUAL"><%=(UpdateRecruiting.Fields.Item("cs_additionalinformation").Value)%></textarea>
what I'm doing wrong?
I've been searching for an answer to this for quite some time now and have found nothing, so maybe (hopefully) someone out there will be able to help me.
At my work, we have a lot of folders for different jobs we've done. And right now, we have more than one person making the folders for all the new jobs that we get. I am trying to make a database were it will only show the jobs that have not had folders made. In order to do this, I've created a field titled "Initials". I want the webpage to pull up all the records where the Initials field is empty, but I'm having trouble doing that. I've tried a few different things and have found no success.
I'm not having a problem accesses the database or updating it, just displaying the right information. I'll give a little illustration (because I'm never good with words):
Say I have 3 jobs: Job #1, Job #2, and Job #3. Someone has already made job folders for Job #1, but Job #2 and Job #3 still need to be made. Since Job #1 has been made, that means there are initials in the initials field of the database and thus, I do not want that Job being displayed on the "To Be Made" page. Job #2 and Job #3 do not have initials in the initials field and as such, I want to display those jobs....
I have an asp page that displays informaton from an Access database. I want to create a form that allows users to display only data that matches their search criteria.
I have made many forms like this in Front Page with the Database results wizard, but I want to manually code it. Code:
I'm having a problem with this code:
Code:
<input type="hidden" name="lastdate" value="<%=now%>">
not returning the "seconds" portion of time. It writes the date and time - but only to the minute. The seconds are 00 each time. Ex. 1/29/2005 1:47:23 PM is what I want and 1/29/2005 1:47:00 PM is what I'm getting.This is the result I'm getting on two separate DB's on two different servers. I'm sure there's some glaring problem I'm overlooking because I sure can't see it.
I am rebuilding a site for an internet radio station. One part of the site shows a "Now Playing" element with a simple text screen that a backend ASP script has retreived from a server and parsed. However this little text feild updates every 3-4 minutes when songs end. However the only current way I know to update the string is to automatically reload the page every 3-4 minutes.
This is a real annoyance for both myself and all of the users. Is there anyway with ASP or another language to only update the text string every 3-4 minutes without having to reload the entire screen.
I'm looking to find or create an ASP script that will take a string, examine it for a search term, and if it finds the search term in the string, return the highlighted search term along with the words that surround it. In other words, I want the search term highlighted and shown in an excerpt of the context in which it appears.
This behavior is most often seen as part of a search engine. In my case, I want to use it as part of a content "scanner" that utilizes a screen scraping component.
I have a big frontpage, and it takes awhile to load, since i pus on Response.Buffer = true and i want to speed it up. is there a way to flush a portion of the page, preferably the header table?
View Replies View RelatedI am using a Relational database for my site and i have the following tables:
FIXTURES, GAMEDATES
the fields in FIXTURES are:
GameDate
Home
Away
(All of the above are numerical fields)
the fields in GAMEDATES are:
DateID(integer)
GameDate(#Date Field#)
What i have done is in the GAMEDATE field in the FIXTURES table i have used the ID number of the date that i wish to assign to that record - using a LEFT JOIN to display the actual date that is pulled from the GAMEDATES table (That which corresponds to the relevant id used in Fixtures)
The problem is that in some of my code i want to display records using sql and sometimes in the where clause i use the following:
WHERE Fixtures.GameDate<=(Date())
obviously meaning WHERE GAMEDATE is LESS THAN or EQUAL to TODAY.
The thing is when i use the join it does not use the where clause and displays all of the records in the FIXTURES table.
Does any one know how to get around this, i have not received any error messages it just isnt displaying the right data
Im comparing values in a field while doing a loop if sAct<>myData(5,i) then At the end of the loop I make the value of sAct equal the current myData
This will work when comparing other fields withing my recordset (so I know the statement works) but it will not work for the field I want to compare. The only difference with this field is that it has null values. Could this be the problem? if so, how do I deal with nulls?
I have a input form with 5 fields. One of the fields is MajorNo and the other is named Description.
I have a reference table in my MS Access database (tblMajor)that lists the major numbers and their descriptions.
I would like to have the description field in my ASP automatically filled based on the major number entered on the form, so the user will only need to input the major number when submitting to the Access table (tblSalesTotal).
I am trying to pass a hidden field value on a form into another field on the
form so that it can then be inserted in the database, to enable me then to
reference that number at a later date.
(The hidden value (1 for example) would then automatically get passed to the
other input field.)
The code for the text field that allows users to type an number into it for
submission to the db is below, but what code do i need within the hidden
field to populate this text field below so that users do not have to type the
number in? Code:
I have being working with making an edit field over the past few days. The edit function is now working fine. The edit fields that i have are for id, subject, notes, timedate.
All of the edit screens are one line text screens. What I want to do now is increase the size of the notes box to a larger textarea type box to make it easier to edit notes. The notes field in the db is a textarea field. Code:
When you select the "Country" field in a Hotmail "get new account" link, the field "State" changes automatically, giving you the correct States that belongs to the chosen Country.
View Replies View RelatedI have XML and XSL documents stored in SQL Server 2000 field. On the asp page i will be getting these documents from the database and then displaying the content of the XML document according to the XSL on the asp page. How can i do this?
Also after getting the documents from the database do i need to store these on the server as .XML and .XSL and then read through these or i can directly read from these document without saving these physically.
Archived XML and XSL documents are attached.
I'm pulling data into ASP from Sybase IQ. When the data is in the
database its displayed correctley: //C://.... When I pull it into an
asp page, the formating changes, and a few of my slashes disappear. Is
there a special method of pulling slahes into asp?
I have this error: [object Error] WinHTTP returned error: 12006 The URL does not use a recognized protocol Code:
View Replies View RelatedSay i have the following names displayed on a page.
ABCD
CDFG
FGHI
Now if i click on ABCD,this name should get displayed in the text boc.I dont want to have a submit button.
I just want to basically select this name and the moment i select this name ,it gets displayed in the text box and thn i hit submit and the value in the text box hits the DB.
I have an access database and users can search through it. Is it possible to display the first 20 results on one page and then display the next 20 on another page and so on and so on..
View Replies View RelatedI have a requirement to display a message and then redirect the controls to
some file, I tried with the below method but its not working, where as If I
use server.transfer or server.execute it works but I cant give relative Url
(it will dynamically genrate), If any one has an alternate way, pls respond.
ShowMessage("Hello World")
Sub ShowMessage(sMessage)
Response.Write "<script> alert("& Chr(34) & sMessage & Chr(34) &" );
</script>"
Response.redirect "xyz.asp"
End Sub
When I retrieve this data into standard text boxes (using ASP/ADO) so that
the user can update/file the following problems occur on what I would call
price fields:
10 << I want 10.00
11.6 << I want 11.60
12.89 << this is fine
My MySQL DB holds prices as decimal(10,3) so I know the decimal data isn't
chopped at this point.
Before the data is displayed in these boxes I created the below function to
parse the data before it is written to the boxes: Code:
I'm sure I'm missing something completely obvious, but I can't figure out what. I have a path to an image file stored in a database. I'm trying to align the image to the right, but nothing seems to be working:
Response.Write("<img src='" & rs("faculty_link_to_photo") &"'>")
dispays the photo without any wrapping, but when I try the following, the images go all over the page:
Response.Write("<img align=""right"" src='" & rs("faculty_link_to_photo") &"'>")
Can someone tell me what I'm doing wrong?
I have ASP (classic) code that writes out a table and sets the <img....> tag
with a virtual directory source, e.g. src='/test/imghold/xyz.png', and the
images do not appear on the IE page. The code is from a production site
that works fine.
We just duplicated the web site to one named test and now
the images do not display. The IMG item is in a TD element of a table.
Also, I looked at the "view source" of the page and it shows the <IMG
src='/test/imghold/xyz.png'...> just fine. I even tried it with different
images and none of them show up.
I have a web page that displays properties for sale. The web page links to a database.
The page shows information in the database and the path to the picture.
The code is:
<p><img border="0" src="file:///D:/HousePics/<%response.write
rsData("id")%>.jpg" width="350" height="262"></p>
the rsData("id")% gives the name of the picture file and appends .jpg to it.
When I browse the page on the local machine the page displays ok and the
graphics show up ok.
When I browse to the page at work the grpahics don't show.
Permissions on the folder 'everyone full control', web sharing is enable
for the site.
Following is a function on button click event to display the details of an user.if i include this function page is not displaying.can u tell me where the mistake is? Code:
View Replies View RelatedI done Internet presentation for my client and presentation is placed on Brinkster...
Displaying movies is a part of presentation...
Those are .mov files...
As movie container I use Quicktime...
My problem is:
I have to wait to full movie loading...
Wait and wait...
When the movie is loaded then display starts...
Sometimes, it can take a long time...
I want to achieve effect with movie slider in my Quicktime container...
In other words, I want that movie begins to play before the end of full loading...
How can I achieve this?
My code is here:.....
This code displays all the pictures in a defined folder as thumbnails. That works fine. But I would like to have it roll over onto a new page after a certain number of thumbs have been displayed and a back forward message. Code:
View Replies View RelatedI have a loads of records in an Access database relating to publications. The publications come in 3 forms, pdf, Word or .htm so I have fields for each called PDFurl, Wordurl and Publink. What I want to do is, if any of those fields contain a value then display an appropriate icon (which will link to the publication).
I'm ok with the latter part but how do I determine if any of the fields have a value and if so display the relevant icon? Rather than do a load of if then statements I was wondering is there a quicker way of doing this, perhaps using a Case?