I have a recordset containing many fields from one row of data populated by an SQL query.
If I return the entire recordset in one row with the column headings the table would scroll off the right of the screen.
What I want to be able to do is to create several tables, one below the other of five columns each to display the data.
This is fine if I am returning just data, but I want the field.Name as well as the data - which is causing me problems.
I have a form in my HTML page and I require a number of checkboxes. These are to be dynamically generated from an Access database. The code below will work but it will only create a single row. How can I include the <TR> tag inside the loop - I'd probably want 4 cells per row
<table>
<tr>
<%
Do until rstCategories.EOF = True
Response.Write "<TD width=200>"_
& rstCategories("strCategory")_
& "<input name=chkCategory type=checkbox value=" &rstCategories("lngID")>"_
& "</TD>"
rstCategories.Movenext
Loop
%>
</tr></table>
I 've built a site for a client using .asp and eveything is working fine
except I cannot figure out how to wrap text around an image. Everything is
pulled from the database using response.write. The code works correctly but
I just can't seem to figure out how to do it? I've been searching for weeks
about info on how to do this - to no avail
I have long list of names that I would like to wrap across multiple columns (like a newspaper). Are there any suggestions on how to go about this?
View Replies View RelatedIs there a way to prevent IE from forcing a line break? Below in LISTING 2,
you notice the table background image extention of '.jpg' begins a new line,
instead of staying on the same line as it's file name. Same happens with my
javascript onclick event, IE forces a line break and breaks my code. In my
asp code, you notice I'm inserting line breaks, but IE seems to do what it
wants. I should note, the below HTML results is actually 1 table of 40 or so
that asp builds as a string. Code:
I have script pulling text from a databse which is just the name of a file, e.g: test and I have code which puts a hyperlink around it, for example: http://www.myserver/files/test.doc , so that when the user clicks on it the file opens up for them. How do I check that if the name of the file is a particular filename the address is different.
Basically 1: if filename = test1
address = http://www.myserver/files/test1.doc
2: if filename = EXTERNAL
address = http://www.myserver/EXTERNAL.doc
Here's my code so far:
<TD WIDTH=83 class="body"><P><A HREF="http://www.myserver/files/<% Response.Write RSEmps("fileName")%>.doc"><% Response.Write RSEmps("fileName") %></TD>
how to wrap text on a button.
View Replies View RelatedI ran into a little problem with wrapping text and found 'a' solution. The problem was when I read in text from a DB table field to populate a HTML table. I found a line of text to wrap mysteriously after column 37 even when the field was defined with a max character count of 100.
I removed the <td> tag's 'width' attribute and this took care of the wrapping problem.
I hope this will help someone else.
I 've built a site for a client using .asp and eveything is working fine except I cannot figure out how to wrap text around an image. Everything is pulled from the database so the code works correctly but I've been searching for weeks about info on how to do this -to no avail.
View Replies View RelatedI am working on a date function, which takes a YYYY-MM-DD input and splits it into dd,mm,yyyy format. e.g:
string1 = "2006-10-20"
Function stripDate(str)
str_len = len(str)
if str_len = 10 then
str = replace(str, "-","")
str_yr = left(str,4)
str2 = right(str,4)
str_mo = left(str2,2)
str_dy = right(str2,2)
stripDate = str_dy & "," & str_mo & "," & str_yr
else
Exit Function
end if
End Function
test = stripDate(string1)
sample output: 20,10,2006
I then want to pass the sample output into another function, but in order to do that, the date variables must be split with speech marks as follows:
"20","10","2006"
but I can't work out how to include that in the stripDate function so that it wraps the variables in speech marks. Whenever I try to include the speech marks the code returns the usual error about unterminated string constants e.g. if I replace the final line of the above function with this:
I cannot find any information on how to insert an image into a block of text
and have the text wrap around the image. All if the text and graphics in
the client's site are being pulled from the database using response.write.
When I write straight HTML, it is easy to place an image into a block of
text and align the image right or left, having the text wrap around the
image.
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 RelatedI 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 need to include the html inside another html, though it might appear simple, the catch is this, my one html is in one server and my another html is in another server.I cannot read the html and stream it as it has images and their path gets changed when i do that.
More over i donot have any control over the html which i am going to include all i have is a url http:abcxx.htm whose content i want to show in another asp page. The technology is ASP (vbscript and javascript).
I want to be able to send two sql tables to access db at the same time
View Replies View RelatedI 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 RelatedI 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"
Does anyone have some sample code on how to get all tables names in a MS Access database?
View Replies View RelatedI am trying to list data from the DB from three different tables. The first table is creditors, the second is statements and the third is payments. I don't know much about inner joins and I'm not even sure that's what I need to do. The first section on the page is detailed information about the creditor.
Below that is a section for a summary of all statements from that creditor. Below the statements section is a section for listing payments from that creditor. The 'creditors' table has a field of "credID" as well as the tables "statements" and "payments".
The "statements" table has a "StatementID" field and the "payments" table has a field of payID. What is the best way to list the statements and payments from a particular creditor?
Ithe goalposts have been moved (yet again!) and the database that was one, may have to become many, being used on subdomains of the same server sharing some information but not all from a 'global' database.The solution I initially found was to used linked tables and developing it on pws - this was perfect. I linked local databases to the external table data in the 'global' database hey presto the application ran smoothly. There was only 1 connection to each local database and I could retrieve all the information I needed from the global one. However on uploading I have no idea how to set this via asp or sql as online the path of the linked tables is what was on my local machine and I have found no way of being able to edit this or indeed know if this is possible.
View Replies View RelatedI've got three tables:
tblEvent
--------
Id (PK) | Event_Name
tblDelegate
--------
Id (PK) | Delegate_Name
tblBooking
--------
Id (PK) | Event_Id (FK) | Delegate_Id (FK)
I need to retrieve a recordset with the following information:
Booking Id | Event_Name | Delegate_Name
Can anyone see how to do a SELECT statement to do this?
I dont even know if ASP is the right language to be doing this, but what I am basically trying to complete is a way for a dropdown box to come, and depending on what they select data will go into a table. For instance, the dropdown will what type of taxpayer they are and if they select individual, the offered services will appear in the table.
View Replies View RelatedI have an application that creates online quizzes, each quiz has a results table generated by ASP on MS SQL Sever.
What I want to do is compare the SQL structure / code of the table I am about to create with the SQL structure / code of an existing table (previously created in ASP) to see if they are the same.
So how can I get the SQL structure of a table that already exists in my database into an ASP page?
I have a database with 2 tables in it.
Each table contains the fields: ID(autonumber),Title, Artist, Description, DiscNo, and TrackNo. The second of the two contains an additional field: Price.
How would I make an asp page in which a person enters DiscNo and Price into a form and the code would read all the fields of that record from table1 and then add those and the Price into table2?
I am looking for code that will go through all tables in MYSQL db and transfer records into text or excel files.
strSQL = "SELECT x.CountryId, x.CountryName, y.SiteId, y.SiteName, z.LocationId, z.Level FROM TableCountry AS x"
strSQL = strSQL & " INNER JOIN TableSite AS y ON (x.CountryId = y.CountryId)"
strSQL = strSQL & " INNER JOIN TableLocation AS z ON (y.SiteId = z.SiteId)"
Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error (missing operator) in query expression '(x.CountryId = y.CountryId) INNER JOIN TableLocation AS z ON (y.SiteId = z.SiteId)'.
/system1.asp, line 21
i have an sql query that needs to join 3 tables to get the desired answercouldnt think of a better way )
Code:
SELECT *
FROM Sold INNER JOIN Serial
INNER JOIN TempSerial ON Serial.SerialNo=TempSerial.SerialNo
ON Sold.SoldID=Serial.SoldID
WHERE Sold.CustomerCode='"&customer&"';"
are you able to open two Access tables at the same time or is this bad coding practice?
View Replies View RelatedHow do you go about searching three tables at the same time? I'm using Dreamweaver MX, but I can also hand code it in if know one knows the dreamweaver method
View Replies View RelatedI've a (classic) ASP web page that has several tables on it that have
identical columns (headings).
When these tables are displayed they of course have different widths, based
upon the amount of text within each column.
I have been asked to make all tables have identical column widths.
What I thought I would do would be to have some sort of column-width counter
that counted the maximum number of characters in column A in all tables, and
another for column B in all tables. From this I would have to come up with
some algorithm (not yet done) to turn the number of characters into a column
width (based upon font family and font size chosen).
This value would then be put into a programmatically generated style sheet. However, a quick prototype shows that the style sheet appears to be ignored if it's at the
end of the document (even if in a <head/> tag) and the aforementioned
algorithm would appear to be rather complicated.... Code:
I have this page with a drop down box which loads the itemnumbers dynamically. However, I want it to NOT load the numbers that already exist in the weborderlist. What can I do to my SQL statement to make this work?
Code:
SELECT (SELECT img_inv.item_num from img_inv, weborderlist WHERE img_inv.item_num <> weborderlist.item_num and weborderlist.orderid= '1') as test
Okay, I have a db that contains 1 table. it has some house info and stuff in it, but I want the updates and news and stuff on my site to be dynamic.
So should I make a new table inside my DB and use that alongside the house info table? What would be the best way to accomplish this, and if possible, do u have to set a recordset up for EACH table?