HTML snippits out of microsoft access
March 15, 2010 2:53 PM Subscribe
Create a table of html snippits in microsoft access from data already in the database.
OK. Basic question here which I can't see an obvious way to do. I have a bunch of data that I want to group and then output as a set of HTML snippits to be uploaded to a larger web database.
Specifically, I have a table of counties and cities. I want to
a) create an html table for each county that lists the cities within that county. Then,
b) I want to insert this snippit into another html page (which already exists.)
I can do B) but am having trouble with A). Based on my rudimentary way of doing B, I need a way to do this that puts the HTML snippits from A into an access table of their own, with each row being a county. Essentially, a table that has two columns: county, and "html table of cities for that county".
Help me mefi!
OK. Basic question here which I can't see an obvious way to do. I have a bunch of data that I want to group and then output as a set of HTML snippits to be uploaded to a larger web database.
Specifically, I have a table of counties and cities. I want to
a) create an html table for each county that lists the cities within that county. Then,
b) I want to insert this snippit into another html page (which already exists.)
I can do B) but am having trouble with A). Based on my rudimentary way of doing B, I need a way to do this that puts the HTML snippits from A into an access table of their own, with each row being a county. Essentially, a table that has two columns: county, and "html table of cities for that county".
Help me mefi!
Response by poster: Thanks lester -- I used that as a start to my google fu and then found a detailed answer on how to concatenate the rows in access here.
Apparently this is easy to do in mySQL but hard to do in access. But now all tidied up!
posted by mtstover at 7:57 AM on March 16, 2010
Apparently this is easy to do in mySQL but hard to do in access. But now all tidied up!
posted by mtstover at 7:57 AM on March 16, 2010
This thread is closed to new comments.
so all the non changing html was in the query, and inserted into an empty table each time.
posted by lester at 5:31 PM on March 15, 2010