I would like to change it so that it displays only the first 40 (or so) characters from the record being pulled from the MySQL DB producing a result more like this:
Is there a way to change the SELECT call to MySQL so that it retrieves only the first 'x' characters found in the record? Code:
I have a database with table name as test in that i have 6 colums they are:
name varchar (20)
address varchar (20)
position varchar (20)
nametype1 varchar (20)
nametype2 varchar (20)
nameval varchar(20)
now in the nametype1 and nametype2 there are values like:
Using ASP I'd like to modify a string that contains HTML. I need to modify the content (the bit that the users see) but not the stuff in the tags. For example, if I had the following string Code:
View Replies View Relatedi upload a document in my server and i want to dispaly the content of document along with the pictures in the HTML format using asp.
View Replies View Relatedi need your help. how can i display ftp-content (files which lies on a ftp-server) on an asp-site? do there anybody have an idea, how can i solve this? at the moment we list the files per webfolder in our web. i use for handling the filesystemobject.
my environment:
1x ftp-server (win2003-standard edition; IIS 6.0)
1x web-server (win2003-standard edition; IIS 6.0) ...
I want to store HTML content of a URL into a string using ASP is there any provision for that ? for example i have a URL like www.mywebsite.com/default.asp and i want all HTML content of this page into String variable in my ASP page .
View Replies View RelatedI have a csv file that has 2 columns..."Name" and "Team" I would like to be able to have 2 dropdown menus on a webpage showing both of these and a method (a post I guess) to change which team they are a member off...For example Joe is in Team 1 but moves to Team 2, from this page the user can change Joe to Team 2..
I would also like to be able to add new members and remove existing ones.
what I want to make actually is to take the results of a search engine that I use, which are in form of HTML or ASP and transport that results in a DataBase. For example, I wont to place as registrations in the DataBase the equivalents URLs and their descriptions from the results of search. I use MS Access, code asp, HTML , Javascript .
QUESTION! How can I insert the content from an HTML or ASP page into a dataBase? How can I determine from what point to what point a string it will be entered in the first cell of table and afterwards in the next and next ....
I need to create a module where a technical novice can send an email newsletter (that has already been created and uploaded on a server) to a list of subscribers.
I know this can be done using CDO.Message and CreateMHTMLBody
My question is how can I add a few lines of new content like say a header and footer and may be some personalization (like a direct unsubscribe link for each subscriber.) to an already existing html file before emailing it out.
When I use IIS 6.0 to display static content everything works according to plans. Now I have created an asp page even though there is no dynamic content at the moment. The web page's name just ends in "asp" and has the Code:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
at the first line of the code.
When I try to link to this asp-page I get an error code saying "Http 500 Internal Server Error". I then disabled the "friendly http errors" and got this information.
"Asp error Asp 0203"
"Invalid code page"
"The specified code page attribute is invalid"
I should also add that I have enabled/allowed asp as extension in IIS manager.
Anyone who knows what I can try to get IIS working with dynamic content too?
i have a self submitting form which validates itself using post, once validated the form goes 2 another page . this page uses the GET method to get the data from the previous page. however this is at present not working . I would like the variable to be passed server side not client side in vbscript the pages are in ASP .
View Replies View RelatedSee Example of script below that works fine. I want to add the feature to this where it will tell customer that they missed a field, "click here" to go back & try again.
Does not need to be fancy telling them which field they missed. (Although would be nice) Can even require all fields to be filled out, or do again.
Currently it kicks you out when e-mail field is empty, but not on any other field.....
So I only get the date, and not the time. What confuses me is the possibility that the string length can vary from date to date, else I'd use a trim, right?
View Replies View RelatedI want to ask what are the possiblities to truncate data
from 1 million dollars to 1 dollar by using formatCurrency and
CCur functions?
The ASP page has code <%= formatCurrency(rs(14)) %>, the database
rs(14) is 100000000. But when it displays it in the screen,
it shows $1.00 with code <%= formatCurrency(rs(14)) %>
There is another place with code using CCur and formatCurrency
together, i am not sure if this is ok.
<%
amt_of_deposits = amt_of_deposits + cCur(rRes("natl_trust_tran_amt"))
%>
<%=formatCurrency(amt_of_deposits)%>
I use this code to assign the current usersname to a variable called "username"
username = Request.ServerVariables("AUTH_USER")
If i wrote this
response.write(username)
I get something like myomainusername.
I just want the "username" bit not the "mydomain" . How can I truncate it?
I have files names like bcd.jpg, 1234567.mpg etc in my DB. I need only the file names. I know the truncate method but it's no good here. How do I cut away the extension part?
View Replies View Relatedi want to convert my txt file into a html table for display . But i dun want it to go through db .
View Replies View RelatedI need to display a lengthy html source code within a text area. The problem is, a part of html source code is displayed in the text area and the later part is displayed in the actual html page in which I have the text area. i.e the the html source code is treated as a part of the actual page.
I want to show the whole html source code (which is from the database column) in the text area. Is there any special way to display the html tags in a text area. Hope I have made myself clear enough. how to achieve this?
I was thinking about create a web page to display my log files. I have a folder that holds all the notepad files (logs) on my hard drive.
There is a new file will be created everyday. Is it possible for me to create a webpage (ASP or HTML) to display all the logs?
How to display html files content in a asp page through server.create object
View Replies View RelatedI am displaying the data into HTML table into a EXcel file using the REsponse.header and content type, The data retrieved from the database is sucessfully displayed and I am able to open Excel application and save it. But in One of my TD tag I have a image <IMG> tag which should disply the image, but in the excel application the image is not loaded, If I open the table in web browser the image is visible.
Also if I select the save open form the file download box, there is a blank browser window still open, I open this file with window.open functionality. Can somebody suggest how to close the blank window when the excel file is saved on the client PC instead of opening.
i have an asp page which creates a object using server.createobject and
uses its method. example:
set obj1= server.createobject("test.test") ' test is a dll
tmp = obj1.method() ' it returns a BSTR string.
i want to display tmp in HTML. when i tried to print tmp like
<font><%=tmp%></font>
i get some garbage value.
I'm incharge of updating the stats on a chl hockey teams Web Site. I
would like to know if there is a way to be able to save
the content of the CHL Statistics WebPage on our Server and using it
to update our Microsoft Access 2000 database.
If it possible, then I would take the content of that page. Execute
some code that will take this information an place it in our
database on our server. By doing this, our Team WebSite would be
update automaticaly at a time that I specify on our server.
At this time, I have to open the CHL Statistics WebPage. Then Save the
HTML page as a txt file, upload it on our server via FTP, then execute
my my code that places it in our database.
Could you send your suggestions to Join Bytes!?
I would like to display a lot of binary source image in one html document. Those image are read from ms acess database
I know only read and display one image, such as:
Response.ContentType = "image/jpeg"
Response.BinaryWrite rs.Fields("iamge")
But, this cannot display any text and other image, only an image can see in the browser.
I have a table having 3 columns. There is a checkbox for each line. I
need to get those lines whose checkboxes are checked, and show those
lines to another webpage. Is there any way to do that? My concern is
that all information in the table are in <tb></tb> pairs without any
name tag. Any idea?
I'm doing a content management system, whereby the user can enter the HTML code for a currency symbol, eg £ for £.y . when I bring this data backup, say they want to edit the settings, then my ASP/HTML page is rendering the HTML code, eg £, rather than showing the original value, eg £.
If for example I put a space between the '&' and the 'pound;', eg & pound; then this will cause me problems because the user will think that they have to a put a space in or they file it with the space, which means the HTML code won't work any more. Is there a way round this?
I have started doing SEO for a website and I'm trying to get a feel for how the website is set up.I dont know which file stores the content....
In the asp file page there is a string of code that reads:
<%Call writeContent(2,1)%>
I believe it is what is telling the server to find the article, but I dont know where it is.Does anyone know what else to look for?
I am having to make sites accessible where images are dynamically generated.
'Display the graphical hit count
Response.Write("<img src=""counter_images/")
Response.Write(Mid(lngVisitorNumber, intWriteDigitLoopCount, 1) & ".gif""")
Response.Write("alt=""" & Mid(lngVisitorNumber, intWriteDigitLoopCount, 1) & """>")
How do I include the width and height attributes in this code?
What is "active content"? My ASP page just returns HTML....
I have a page with an .htm extension that has a form whose action
is an ASP page which generates a report after updating a database
with the form data.
Under Windowx XP SP2 the IE6 "Information Bar" has the message:
"To help protect your security, Internet Explorer has restricted this
file from showing active content that could access your computer."
I would like to have a PRINT button on my page, that redirects to another page which is more printer friendly.
I am pulling the content of a database (msAccess) into the initial page, and want that content to carry accross..
Here is an example of the page http://www.australie-voyages.com/en...-tours.asp?id=8
can someone help me. I'm writing an onlineshop in asp and for the shopping cart
i use an array. If someone wants to delete some articles from the cart, i have to
delete them from the array. How i delete only one article (on line) from the array.
i am building some web page with template engine and i run on one problem: i want to import a content of some file and then use it in asp script so the solutions are this:
1: Create file system object and use ReadAll to read the content but there is a problem because it dosent render the importet file i get just the asp code
2: Create XML object and load the file into the xml but here is another problem this proccess takes quite a lot of time so it will be very slow for the web site especially that i want to import more the one file...
3: Create file system object and user ReadAll to read the content and then use eval(reasponseString) to execute this code... but i dont belive to much in this solution i dont know why but it seems to me it's not right.....
If you needed to have a side bar, that had room for 2 or 3 graphical ads, and you had say 8 ads to pick from, and you wanted each page to just randomly load ads but never put the same 2 or3 ads on the same page...
View Replies View Related