I am using a WYSIWYG editor for articles and the article text is being
inserted into a SQL db field called ARTICLEBODY.
Question:
On my homepage, I only want to display the first 400 characters of
ARTICLEBODY field. I am using the LEN function and it does what I want.
BUT, is there a way to not have it cutoff in the middle of a word?
I try to display a combo box which contains String of variable length.But it occurs that only the 10 first characters of one string are displayed.is it a limit imposed by ASP
View Replies View RelatedIs it possible to only show a certain number of characters from data in a database? For example, I have a database that one of the data types is memo and the data in this field for each row contains minimum of 300-400 words. Right now I call this information with <%= rs("content").Value %> BUT I only want to show the first 50 characters then have . How would I go about doing this?
View Replies View RelatedHow can I count a number of characters in a variable.for example I have intTest = 19483, how to get 5?or strTest = "TestTest" how to get 8
View Replies View RelatedHow can I prevent a user from entering more characters than are allowed in a database field.For instance,if a field only allows 6 characters,how do I prevent the user from trying to submit the form in a user friendly way?
View Replies View Relatedhow to Count the number of characters in a variable?
View Replies View RelatedI need to insert some number into database as text. My problem is if I insert the number (ie. 4.0), the value in the database only show (4). So, is it possible to convert a real number into text number using ASP?
View Replies View Relatedhere is the scenerio
in master batch table i have various master batch like
200701-0001
200701-0002
200701-0003
Now each master batch can have multiple final mixed batch like
200701-0001-01
200701-0001-02
200701-0001-03
and this record is inserted in to fmix table.
so i have a form in which i have a dropdown menu in which all the master batch is listed,
i select 200701-0001 and that value is passed to next page where i will enter other fields data and insertion to my fmix_no will be done automatic like 200701-0001-01, 200701-0001-02 and so on,
how to achieve this
so in short each master batch will have more than one final mixed batch.
pls help, also if u have any online contact in yahoo or msn pls send me, i am so confused and badly struck deadline is just couple of hours away. my yahoo id is(E-Mail address blocked: See forum rules) you can PM me i am online right now.
I want To handel the error messages by myself in one part in my script. I know that in VB I can Use the statment - On error resume next And I also know that I can retrive the Error Number In VB with Err.Number.
How can I handel the errors by myself in ASP? I heard about the ASPErr Object, Is it the same thing like the err object in VB?
Can anybody help me with displaying two xml content in a asp page. i want it to be shown with collape and expand feature (with those + and - feature when an xml file is opened in explorer).
i tried having html frames but i am not able to add menu in the same html page. right now i have menu and two text boxes to display this xml content. i want to use something else instead of text boxes to display xml in indented form. i thought i could use browser component in asp page but it doesnt work.
I have an active-x control on my asp that loads a wmv video file.But i have a problem viewing the video until i have download the whole video on the active-x control.
Is there a way to see a portion of the video without complete download?
I have a strange problem on WindowsXP proffessional with IE6 ,when i try to display a tiff file ,it is not showing ,small red x is comming up. I tried by dowloading latest IE from microsoft but no use. This is working fine on win2k IE6.Here is the html file I am using to display the tif file.
<html>
<head>
<img SRC="http://192.168.0.30/test/test.tif" BORDER="1">
</head>
</html>
I make a intranet Project For a Company.In that Project i make some reminders that can send each other users.When the Reminder come it should be alert like yahoo or Msn means Reminder should be show right side of the Taskbar and it's come like fade.
View Replies View Relatedi have just uploaded the new files to a website i have rebuilt. I have refreshed IIS and restarted the website but the new files are not showing through on directories that existed before eg subscribe etc. The new directories that didnt exist before work fine but would the internet connection in our office be caching previous pages that are no longer there and trying to access them?
View Replies View RelatedI'm really trying to make this work. I have a dbtabel with following fields.
ID
PlayerID
Date
Point
I want to show each players point like this "1,2,5,6,4,8,9", but i want the script to first add up which player who has the most points, and then list them in order of wich player who has the most points...
1,3,5,6,4,5,9
2,1,1,3,2,3,6
2,5,6,4,1,1,0
Each row is each PlayerID's row. Is this possible.
my problem is The updates on my asp files are not reflected in the browser. Till recently everything was working fine.
Today I installed new updates on my windows 2000. After all the cached asp contents are appearing and the updates are not getting refreshed. I dont know if this is becoz of the updates on my OS.
I had a file addfield.asp. It was working fine, I made some changes and they worked. But after that my updates are not reflected. If I rename the file to addfield1.asp. I am getting the desired results. Again if I change the contents of this file, they are not appearing.
why some of my graphics wouldn't be showing up? I'm using css and everything looks fine in dreamweaver until I upload it then half my graphics are not visible on the page but they are there because I can still click on them, I just cant see them. Any reasons?
View Replies View RelatedI inherited a database driven site, which displays events pulled directly from an access 2000 database. when these events are edited in the admin system, or when a new record is added (again via the admin system), the record will no longer show up as being editable on the choose_event.asp page. I checked the database, and the changes are being made.
View Replies View Relatedok so I wrote a template based CMS.... A small company requires a website, they come to my site www.mutedesigns.co.uk/sbs and choose a template, pay, register, edit ther details and pages and then view their site simple and it all works yay! Code:
View Replies View RelatedI'm working on a Intranet, and found this code to list the contents of a directory.
However, the only directory I've been able to show is the dir where the script itself is (Inetpub/Scripts).
How can I redirect to a directory somewhere else on the network ? Code:
I have a table called 'players2005' with fields of 'player' and 'pdob' The 'pbod' is a DATE realted to the players date of birth.
Using ASP how can I call the access database to show members that date of birth is today.
I have the rest of the script but just nedd a SQL statement Code:
I've been working on a page at work, which has been fine, yet when ive come to try it at home, i load the page (the page loads fine) but i see all the code etc that was hidden before.
example what i see at the top of the page:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%<% OPTION EXPLICIT %<% 'dim
oCdoMsg, oCdoConfg, st
but i see tons more than that, basically all the code to the next %>
What to only show the Null fields on an ASP Update form. eg.
<% If "Recordset1.Fields.Item("B15-1").Value" = IsNull then %><input type="text" name="B151" value="<%=(Recordset1.Fields.Item("B15-1").Value)%>" size="32"> ...etc
get what i mean? Needs to be per field - as the exact fields will differ from record to record Any ideas?
I'm using AbsolutePage to show the results of my recordset in different pages; of course if there is a lot of data, it's gonna show all the links (for example 100 pages, 100 links) So I want to do something like this:
pag. 1 2 3 4 ... 97 98 99 100
and of course without showing "..." if there are less than 4 pages.
What's the easiest way?
I have a Golf leaderboard based on points given to each player after each match. That works fin, but is it possible to show everys players record after his or hers name. At the time it looks like this.
Mike 7,50
Peter 5,45
etc.
My code is like this Code:
I am using SQL 2000 database and MS Server 2003.
I am pulling in data from a sql table. For some reason, when I include
the following line:
<tr><td><b><%if rs("Street_dir")<> "" then response.write
rs("Street_dir") & " " end if%>
<%=rs("Street_num")%> <%=rs("Street_name")%> <%=rs("Street_suf
fix")%></b></td></tr>
then the following line does not display:
<tr><td><%=rs("remarks")%></td></tr>
The REMARKS data is blank. But, if I remove the upper address line, then
the REMARKS appears. The address is 1111 Main so that does not seem to
be the issue. The address information is VARCHAR fields, 255 characters.
This works fine on another server where my files used to be, but I just
moved to a new server.
I have an upload facility which is working fine. uploads to a folder (photos) through aspsmartupload and database. Ive checked the folder, n database to see if the file is being uploaded and it is.
ITs just not being displayed properly on the site. ALl the pictures come up with a little white box with a red cross in it, in the top left had corner.. so its identidied as an image , but its not showing the actual image. .
I am using ASP to read code from a text file that I am displaying on my
page. Because I do not want the code from the text file to be executed, I
used the Server.HTMLEncode() method to display it as it is in the file.
However, the spaces used to indent lines is still removed by the browser.
I
cannot use VBScript's replace function to replace all spaces with
because that would replace all spaces, including ones that I do not want
replaced as well as majorly increasing the size of my file. Is there any
way to display the spaces used to indent the lines without manually writing
a function to do it?
I would like to have the option to show and include file which has a one line table with a red background and printing to pull info out of a SQL database but only if there is data in the table. Basically it is to show breaking news when it happens before there is an article. The SQL table is called breakingnews and the column is called brknews. If the column brknews has nothing in it, I don't want the table to show up on the page but if there is data in it, I want the colored table and text to show up on the page.
View Replies View RelatedIf you'll notice, there's a comment in this snippet that drops the extension. How can this be modified so that the extension IS shown?
Set myFileSys = Server.CreateObject("Scripting.FileSystemObject")
Set Folder = myFileSys.GetFolder(Server.MapPath("/meetings"))
for each file in Folder.Files
If Not file.name = "index.asp" Then
FileName = Left(file.name, (Len(file.name) - 4)) 'drop the extension
FileSize = cint(file.size / 1024) 'convert into kilobytes and drop the decimal
Response.Write("<li><a href='/meetings/" & file.name & "'>" & FileName & "</a> - " & FileSize & " K<br>" & chr(13))
End If
next
Set myFileSys = nothing
Showing an HTML file in part of a Webform.I have a Webform with some buttons on the left side of the form. What I want when clicking one of the buttons is to show an HTML document in a part of the Webform (as if it was a Frame page).
View Replies View RelatedI saw a while page a link to show folder details ie folders / files in a directory
let me know any links to tutorials
How do I display 'Please Select' as the default value my code is below.Code:
<option selected>Please select</option>
<%SQLStmt = "SELECT magcode FROM Magazine ORDER BY Magcode"
Set rsDistMags = Connection.Execute(SQLStmt)
Do WHILE NOT rsDistMags.EOF%>
<option value="<%=Trim(rsDistMags("magcode"))%>"<%If Request("magcode") = Trim(rsDistMags("magcode")) Then Response.Write " Selected" End If%>><%=Trim(rsDistMags("magcode"))%></option>
<%rsDistMags.MoveNext
Loop%>
</select>