In one of our applications we have product id field which sometime contains ' . When doing a search the sql breaks due to this. I cannot use replace function to remove this is there anything else I can do so that this works
strProductId = 2277'778
sqlstr = " Select * from productdetails where id ='" & strProductId & "'"
In this instance the sql breaks and gives me an error. how i can solve this.
Im developing a site for an organisation im a member of. Im trying to make updating the site a simple as possible for the organistions staff, some of which are not the computer literate. So i have made a kind of template site where the content of all the pages held in a access db. I have then made an admin backend where organisation staff can login and update the contents of pages simply by editing text in a text box and clicking the update button.
However, i've come across a problem. When users leave a line break in the text box the output page doesnt display the gap. I am using a simple response write to display the contents of the attribute on the page. Currently the only way im managing to get line breaks is to enter a '<br>' into the text box on the admin page.
How could i make it so when a line is left blank on the text box the database records this and displays it on the output page?
this might be a shot in the dark but does anyone know if there is way to code pdf page breaks in webpages. when i print to adobe acrobat my webpages split when there converted to pdf. i want to set the pdf page breaks in my webpage.
View Replies View RelatedI'm trying to save to a message field with the field type, memo.
Say I save the message:
"Test 1
Test 2
Test 3"
When I response.write it, it will turn out like " Test 1 Test 2 Test 3"
losing all the line breaks and such
If I response.write it within <textarea> </textarea> tags it comes back
I created a form mail script. I am receiving an HTML email from the user input. However, If the user enters a line break in the comments field I am receiveing a single block of text in my email.
Is there a way to get the line breaks to show up in the email. I tried Wrap=physical in the input but its still the same.
i am generating report in ASP using sql.but i have problem when i need to have print ,that is when i want to take a printout of whole data i want to break the pages according to the group,but now i get a report with merging of the data.I want to take a print out groupwise page break. sample asp file is attached with this mail .
View Replies View Relatedsearched the forum many people posted the same thing many times about text areas displaying line breaks when data is retrived, i know this is the right code
<%=Replace(data, VBCrLf, "<br />")%>
but where abouts do i put this in my asp page.
Preparing a report form in word file using ASP.
How to insert page breaks in word file through ASP to perform a
client side report.
I've 300 records in a recordset sort by name column (not unique) needs showing in 3 pages, 100 records each. At this moment i've stored records having 1 to 100 ID in 1st page, 100 to 200 id in second page and 201 to 300 in third page. but this doesn't have the record sorted actually according to name. Can anyone suggest how i can break records in 3 pages as well as sort them according to name.
View Replies View RelatedI am creating some reports with ASP and have come to a bit of a problem. Does anyone know how can I send a page break to the printer? I need to be able to start different items fresh on a new page and I really have no idea how to do it.
View Replies View Related<%
response.write("Hi" & vbclrf)
response.write("there")
%>
There's no line break, it just displays it as Hithere.
I am building a small CMS for my son's school. Ideally I want to build the system for them and hand it over so that all updates can be done through web-based forms.
So far so good. However I'm having a problem with fields designed to take multi-paragraph stories or articles. I'm using a text area field on the form which saves the data in a memo field in the database. Teachers would typically cut and paste stories from word documents into the text area field.
However when the data is loaded back into the website from the database all the carriage returns have been removed and the story consists of one long paragraph.
Can anyone please let me know how to insert page numbers and page breaks in ASP.
View Replies View RelatedI am trying to modify an existing ASP application that produces forms with several 'blocks' of text that are contained within table cells and which have their own HTML id's.
These blocks must not be split over two pages. Is there a straightforward way of calculating the size of each block/table cell so that the blocks are not split and the form prints on the minimum number of pages? This is an intranet application, so we have a certain amount of control over browser settings, so margin settings etc are not a problem.
We have a page that reads records from a database and displays them. Basically name/address/city/state/zip/county/phone. These records are between 4-6 lines a piece (there are other variables involved).
When printing these records via i.e. we currently have a process where we determine how many records have been written and eventually put a table with .break { page-break-after: always } style applied to it. The problem is, sometimes a page will hold 14 records, sometimes 15, sometimes 16. Is there a better approach to this so that records don't get cut off and it maximizes the number of records that display on each page?
I have used this type of VBSCRIPT code on an ASP page for several years to launch a program on a server from an ASP page:
Dim sh
set sh = Server.CreateObject("WScript.Shell")
sh.Run("any-program.exe", 0 , TRUE)
The code breaks when I installed Internet Explorer 7 (IE7) on a Windows 2003 Server. The error is "permission denied". The error goes away when I uninstall IE7. Have you run into this problem? Do you have a solution that is better than uninstalling IE7?
When I collect the text from a form's text box, I am loosing the page breaks. When using C# in the past, I used this:
Code: ( text )
I'm storing information in a database that will later be displayed on the website and I have a questions about line breaks. My users will type in paragraphs into the text area. Then that information will be saved in an Access Database. Later it will be displayed on the website.
The only problem is that the line breaks that the user makes aren't stored in the DB, so when the information is displayed on the website it doesn't have that formatting (line breaks). I don't want to have to tell the user to type in <br> after each paragraph. What can I do to keep that formatting?
Here is my problem - I have an ASP page the is generating a file with HTML that is being opened with WORD. Can anyone give me a simple method, idea, function, example, resourse, etc.... to figure out how to handle PAGE BREAKS. I am not sure how to handle when to put the breaks in for the report that is being created.
View Replies View RelatedI have a form with a textarea input. The form then stores the text in a database. I want that text to be written to a web page (not a textarea).
Well if I don't put a <p> in between paragraphs, of course the paragraph breaks don't show up on the web page. How can I make it, so when I hit return in the text area, a paragraph break shows up in the asp page?
I've got the following code which should write the contents of a textarea to a '.txt' file:
Code:
set objFileSystem = server.createobject("Scripting.FileSystemObject")
set objFilePlainText = objFileSystem.CreateTextFile(server.mappath("templates/my-text-file.txt"),true)
objFilePlainText.write(strTemplatePlainText)
If I response.write this data before inserting to the txt file, it preserves the line breaks, but when it writes to the txt file it seems to lose all of the line breaks.
Does anyone know how to get this to preserve the formatting of the text being inserted?
Is it possible to create line breaks in a form? All of my informations appears as follows:
This mail message was sent from the www.ccbwebdesigns.com Online Form Email: First Name: John Last Name: Doe Business Type: Anonymous Business Name: In the Dark Phone: 555-GHOSTLY Mail: casper@haunted.com
I would like a line break after each individual text field.
Here is my ASP code....
Dim id
If (id = "") then
id = Request.QueryString("id")
End If
If (id = "") then
id = 1
End If
I use a QueryString request function, so when an id is called, that page loads into the current one. This is perfect, however if say the user directly types a link into the url, like index.asp?id=999, then basically the code is flawed, it breaks up.
Secondly if say a page has been erased from the database, and the link still is available, the code is equally flawed, so it would be good to have a page in my id, say id=50 that displays a page with data from the database, explaining that the page you are trying to reach did not exist or no longer exists, because so far, I get a page error:
ADODB.Field (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/mjhw/functions/functions2.asp, line 21
But how can I over come this.
How is it you should format your ASP code to that when viewing the resulting
HTML text from the browsers "view code" it looks nice with line breaks?
If I have a string and it contrins the following:
Hello world
how are you today?
What script will change it so the string contains?..
Hello world <br> how are you today?
If i'am writing a post in a "textarea" and i use the ENTER (newline) on my keyboard it comes as a line break <br> in my post on the forum.PHP uses "nl2br", but what is the ASP solution for this?
View Replies View RelatedI have some text in my database with paragraphs in it.When I display that info from the database on my website using asp, it shows with out the paragraphs.Is there a function that will Inserts HTML line breaks before all newlines in a string?
View Replies View RelatedI'm using an ASP script to email a form using CDONTS. I'm trying to format the text in the email and for some reason the bottom line either shows up on the same line with the text or two lines down, instead of the line right below the text. What do I have to do to get it down to the next line? Code:
View Replies View Relatedi have a MySQL database and i am using ASP
for one of my forms, i have a textarea form element that is...substantially large (500x300px) users are instructed to hit enter/return on their keyboard to separate paragraphs but i have encountered a problem.
in the textarea, everything is wonderful. line breaks are clearly seen...its awesome. when i submit the form and when it writes to the database (the field is set as 'text'), everything is crammed together...there is just one space between where one paragraph ends and another begins.
has anyone encountered this problem before? does anyone know a solution?
I have an asp page that returns a table from my database. Only about 6 columns from the table are shown on this page. I have the ID column set up as a dynamic link to a 'details' page, so a user can view the rest of the record data.
My database has been growing rapidly, and now when the page is run i get the error "page cannot be displayed".
I believe this is due to how large my database table is because if i delete records the page works fine, as it did when the system was first running. Right now there are 4600 rows in the database and will be growing.
How do I fix this problem, I cannot get rid of any records.
Oh yea, and if i delete the line of code that contains the link, the page works fine and shows the entire table.
Here is the code for the link:
<A HREF="details.asp?<%= "JOB_NO=" & rsResults.Fields.Item("JOB_NO").Value %>"><%=(rsResults.Fields.Item("JOB_NO").Value)%></A>
The following "Send Page" Script Breaks w/Win 2000 & Outlook XP with the error ""The command line argument is not valid. Verify the switch you are using." However, it does work with win98 and Outlook Express. Any ideas on the problem? Code:
View Replies View Related