I am creating a directory of suppliers.I have a form that collects data - business name, address1, address2, town, city, county, country, postcode.
The data is stored in separate fields in an Access database. Another page is used to display the data, one field per line. However, if some of the fields are blank, I want to suppress the blank liens as at the moment I am getting:
My Business Name
1 High Street
Any Town
Any County
Postcode
United Kingdom
When writing to a file, is there an equivalent to the HTML non-break space character? Using “ “ works okay if there are other characters on the line, but when you want several blank lines in a table, if you use “ “ these blank lines are ignored. Code:
View Replies View RelatedI have a text file being create with the FileSystemObject. It's being
built based on results from a SQL query. All this is working fine, but
so that I have a carriage return VBCRLF at the end of each row, I have
an empty row at the end of my text file. How do I delete this last line?
Code:
asp (visual basic script) break long text lines into several lines.
This line of my guestbook (visual basic script) - response.write "message: " & Recordset ("message") & "<br><br>" displays access database field "message" in one line in web browser.
How do I break this text line into several lines? I know in asp.net there is datagrid. Is there something like datagrid in asp. Or perhaps this problem can be solved with htm?
Got a total blank on this one this morning, could anyone point out how I read a specified number of lines from a textfile, the last 30 in this case. (I know I'm gonna have to use the fileSystemObject before anyone mentions it.)
I'm guessing I could use a for i = 1 to 30 loop but I'm completely at a loss this morning if anyone has a nice efficient way of doing it
I'm butchering up the top part of my site so I can make it percentages and make it the same size on every browser.
http://vgameforce.com/gfv8test.asp
If you go there you'll see a black line that disects mario and ninja gaiden. I don't want that line there but I want those to be seperate images.
I know how to read a text file in ASP, I know how to append lines to a text file. How do I simply erase all lines from a text file?
View Replies View RelatedI have been asked to design a ASP page that retrieves the URL and a line of text that contains the version number from a number of pages in our software.
The idea is that if we get a email to our support dept we can check to see what version the client has to ensure that they have got the updated versions instead of getting the client to search through for the Version No.
What I need to know is if I can retrieve a line of text from all our asp pages and then populate it into a table with the page URL and the Version number using ASP.
if i wanted to split the below SQL statement on two lines, what would the
syntax be....
SQL = "UPDATE gallery WHERE g_id = " & Request.Form("g_id") &
"SET g_name = " &
Request.Form("g_name") &
"g_add = " &
Request.Form("g_add") "
This code works great unless the data strValue doesnt have any new lines or no data... i get the error
Microsoft VBScript runtime error '800a005e'
Invalid use of Null: 'Split'
is there a way to allow it to return null or something? Code:
Can anybody give me some tips on the best and/or easiest way to display
multiple lines in a field. The data is collected from a "textarea" field
when the form is submitted, and I want to display all of the data (multiple
lines) in a resulting HTML page. The data displays on a single line
(obviously) and does not wrap without manipulation of the string variable.
Is there an easier way to display the data?
I need to be able to execute DOS command lines via ASP. This would include running an .exe along with passing commands/switches.The platform is Win2k/IIS.Is this easily accomplished with ASP?
View Replies View RelatedIs there a way to remove text box lines so that a user doesn't realize that information is sitting in a text box?
View Replies View RelatedI regularly code in standard asp with MySQL. I have a page which displays records with the background colour of each record table row in a different colour. There are 2 table rows per record. The problem is that at the end of each field in a row, the background
colour stops and then continues in the next field, i.e. the rows look like a brick wall design.
Is there anyway I can adjust my designs so that no matter how many fields or rows I have, the background colour is seamless and the visitor cannot see the start and end sections of each field ?
I entered the data in the database table but, when I print this data on html page thro' asp script. I don't see my new lines. I tried by storing <br>(html new line tag) in the database. Then I am getting only 1st word of each line.
View Replies View Relatedis it possible to count the number of lines i a text file, whith the filesystem object. is it just stream.countlines ?
View Replies View Relatedi'm creating an app where the user will copy/paste BIG word documents into a textbox to save into db. problem is -> some of the documents have a lot of whitespace which needs removed.
anyone know of a script / method to remove multiple lines of whitespace? i.e. if i come aross a large portion of whitespace (extra lines) i want to remove them and leave only one <br /> line in it's place.
When inserting multiple lines into a database asp removes the whitespace so:
hello
all
becomes
hello all
is there any way to detect the return and inset it as intended ie:
hello
all
I know this is Visual basic code, but the response should be global. I one line of code that stretches from here to Mars. Infact, it was used to guide the last probe there. How do I make it go over seperate lines? Code:
View Replies View RelatedI am working with an old line-feed printer text file. There are characters in the first position of each line that tell the printer what to do, i.e. print this line and advance paper, print and do not advance. when processing this text file for conversion to another text file I can't seem to work out the code for merging two lines. For example,
Type: Location: Quantity:
+ 123 London 45000
After processing the line should look like this:
Type: 123 Location: London Quantity: 45000
I understand the concept but have no idea how to actually merge the two lines with code.
I have to make a print page that have 400 lines. How to break it in few pages? How to contrl it?
View Replies View Relatedhow do i display data retrieved from a table 20 lines per page giving a 'next ' button at end of each page.
View Replies View RelatedI have just registered as I have found this very useful saveas asp script but I want to modify it to read in a list of image url's from a text file and save them automatically
Can anyone help me with the looping code to do this?
What I need to know is how to click on a button that is labeled NEW, as in new record, and have the current form open to data input. That is a blank record. After the user then inputs the data to all the fields on the screen and hits the SAVE button the record will then be placed into the database table.
View Replies View RelatedI am trying to use AUTH_USER from request.servervariables but the field is
blank. I am using Windoze server 2003 with IIS5. I know there is a fix
because I did it a long time ago with our old NT server running IIS4 but I
cant remember how I got it to work. We are all authenticated users on our
Domain so this is available, I am able to get IP info and such. I seem to
remember some kind of ASP code that did the fix by altering the way the web
server displays info.
The host Im useing is useing plesk as its control panel if anyone has ever heard of that...I hadnt until this site.
when I try to load a asp page on my site it just loads a blank page.
The page is a data base editor page that I had built useing fp 2002
all my other asp pages load fine.
But this one just loads a blank white page
No errors no nothing. Code:
I had a problem for a while where data was added on its own, and BLANK data. I found out it was because i was opening the processPage.asp to see if it was working, so that was inputting data out of the form that wasnt there. So i get blank data. Is there anyway i can make the process work ONLY if there is data in the form?? Code:
View Replies View RelatedI have a drop down list, values coming from a db, when I come into the form I want it to have no value - how do I do this? Also, if I want to capture the value that a person selects from the drop down list do I need to use a session variable if I want to print it to the screen after they select it?
View Replies View RelatedI want to clear the date in a field in an access table by entering a blank. Does anyone know the syntax for that in the select statement? This is via an asp page
The select statement I am trying to use
<code>
strQ ="Update Inquiries set ShutOffDate= 00/00/0000 WHERE CustomerID = "&CustomerID&""
</code>
I'm getting some errors in my .asp code somewhere but I can't seem to figure them out because all I get is a blank 500 error screen. I don't get any description of the error, just a blank screen so I don't know what the problem is.
Just wondering if there's a way to get the results easily because I do not have admin rights to the server so I can't make a custom 500 error page or i would.
We use Vignette V5.6 to display our site. In our CMA site, we have a page which has FRAMESET and in one of the frames we call a ASP page. There seems to be some problem that the frame shows the ASP page is blank. When we restart the IIS it works fine. But after some time it again shows the blank.
If we get one blank page, all the asp pages under the same virtual directory, called in the Frame shows blank. FYI. The Vignette template which contains the frame is marked for NO caching & For itnernal use only.
All my fields give that error when I try to leave it blank when inserting a new record. The field is not required in the database, so what do I have to do to insert it as blank?
SQL:
Code:
INSERT INTO Tablename (REQUIRED, NOTREQUIRED) VALUES ('tag', '')
Error:
Code:
[Microsoft][ODBC Microsoft Access Driver] Field 'Tablename.NOTREQUIRED' cannot be a zero-length string.
I want to know how I can check if a querystring exists, whether it has a value or not.
Basically I would like to use test.asp?login without having to use ?Login=blah.