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 ?
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?
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:
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.
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 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:
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.
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?
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.
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.
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:
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.
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?
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:
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?
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?
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 ?
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:
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"