Still that space. I have no empty records in my database either, I get that blank space on any query that starts on a even row.
Here is my Query at the start:
<CFQUERY DATASOURCE="store" name="categories">
SELECT SubCategoryID, SubCategoryName, ManufacturerID
FROM...
I can have an even or odd number of rows and it will still leave that blank. I tried the thing you suggested in the above post but just got this error:
Just in time compilation error
Invalid parser construct found on line 71 at position 21. Cold Fusion was looking at the following text:
NOT...
I have a WHERE clause to pull only certain rows from my database and if the database starts on an even row, then it will skip a table entry like this:
Bat *
Cat Mouse
Dog Bird
* - this is where it leaves a blank
Otherwise if it starts with a odd row it works perfectly fine.
Hey thanks a lot. You actually read my question unlike iza who was very "snippy" in his reply. I got this to work but there is just a small problem with how it displays. I figure just put all the odds in one column and all the evens in the other, How can I do that?
Well SORRRRRRRRRRRRRRRRYYYYYYYYYYY. Ive looked at the Cold Fusion Manual. I also have The Cold Fusion book written by Ben Forta. Its about 1000 pages. I read the part on CFTABLE and it shows how to list the information like this
Bat
Cat
Mouse
Dog
but it never said anything about placing it...
Im wondering how I can display a list of information from a database into a table. I want the table to be 2 columns wide and as many rows as there is information. I want the info to be displayed across the rows before the next column-Here is what I mean
I want the info from this database...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.