Record Lines Without Tables
I 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 ?
View Replies
ADVERTISEMENT
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?
View Replies
View Related
I have a database with two tables:
Table 1: Human
Table 2: Exempt
I have created the following code for creating a record, which works fine. But what I would like to do is to check if I add a record on the "Human" table to verify if the record number already exists on the "Exempt" table. I have already created an error handler for it to check if it exists within the same table which works fine. But I can get to do the rest. I created a separate file where I created two functions, but I don't think I did it right. Code:
View Replies
View Related
I need to do a simple but complex thing...
For every record is my users table, I need it to creating a record in 3 tables, with one value (all the same)...
So, in detail:
1 users table
Need to create a record in 3 other tables with the userid from the record it added...
e.g.
From record 1 in Table A, create a record in Table B, C, and D with the value of field 'userid' the value of the 'userid' field from Table A...
Get it?
View Replies
View Related
I know how to create dynamic tables in dreamweaver to display fields and records in a table of a database, but in my case I need to create a dynamic table that lists all the tables in the database, then to click on the one i want 2 edit the data in there.
View Replies
View Related
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
View Replies
View Related
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.
View Replies
View Related
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
View Replies
View Related
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 Related
I 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.
View Replies
View Related
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") "
View Replies
View Related
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:
View Replies
View Related
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?
View Replies
View Related
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 Related
Is 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 Related
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 Related
is it possible to count the number of lines i a text file, whith the filesystem object. is it just stream.countlines ?
View Replies
View Related
i'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.
View Replies
View Related
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
View Replies
View Related
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 Related
I 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.
View Replies
View Related
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 Related
how do i display data retrieved from a table 20 lines per page giving a 'next ' button at end of each page.
View Replies
View Related
I 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?
View Replies
View Related
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 Related
I 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:
View Replies
View Related
I'm getting this error message: Error Type:
Microsoft JET Database Engine (0x80004005)
You cannot add or change a record because a related record is required in table 'employees'. Code:
View Replies
View Related
I have an insert record form that posts fine to a db which automatically creates an ID how could I get the next page to do a preview using the ID just created by the DB to go to the right record?
View Replies
View Related
I have a .asp page which lists a date, then a bunch of record lines for data that falls within that date, then the next date and it's bunch of data record lines. e.g.
Ship Date: 04/06/04
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Ship Date: 11/07/04
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
What I want is:
Ship Date: 04/06/04
1: Data xxxxxxxxxxxxxxxxxxxxx
2: Data xxxxxxxxxxxxxxxxxxxxx
3: Data xxxxxxxxxxxxxxxxxxxxx
4: Data xxxxxxxxxxxxxxxxxxxxx
Ship Date: 11/07/04
1: Data xxxxxxxxxxxxxxxxxxxxx
2: Data xxxxxxxxxxxxxxxxxxxxx
3: Data xxxxxxxxxxxxxxxxxxxxx
How can I get these numbers printed againsts the records ?
View Replies
View Related
I want to be able to send two sql tables to access db at the same time
View Replies
View Related
I have a database that has 2 tables linked into it from another database. I am having problems trying to pull in values from those 2 linked databases. One of the tables is tblClient. Code:
View Replies
View Related
I need some help with a SQL statement. I currently have which works:
strSQL = "SELECT * FROM mstJobs WHERE JobStatus = True"
I need to query against a second table but I am not sure of the
correct syntax of the statement for adding another table.. somthing
like this i would imagine... ????
strSQL = "SELECT * FROM mstJobs.pmdata WHERE JobStatus = True AND
WHERE WeekEnding IN tblSuperInput.pmdata = strThursday"
View Replies
View Related
Does anyone have some sample code on how to get all tables names in a MS Access database?
View Replies
View Related