jwoker
-
Posts
14 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Posts posted by jwoker
-
-
Figured it out - Having was the solution.
SELECTprojects.UserId,projects.Name,projects.Categories,LENGTH(projects.GeneratorUse) AS Lgen,LENGTH(projects.FuelTypes) AS Lfue,LENGTH(projects.FuelTypeOthers) AS Lfto,LENGTH(projects.SpecialNeed) AS Lsn,LENGTH(projects.FirePlan) AS LfpFROMprojectsHAVINGLgen > 0 orLfue > 0 orLfto > 0 orLsn > 0 orLfp > 0 -
I want to list records where there is a value (not empty) in one of three fields and I thought I would use the length function to test if the field had a value or not. I can create a column in my result using length() but can't use it in my where clause. Here's how I initially tried to solve the problem but it failed - hopefully someone can see what I was trying to accomplish and help me get there - Thanks!
SELECTprojects.UserId,projects.Name,projects.Categories,LENGTH(projects.GeneratorUse) as LgenFROMprojectsWHEREprojects.Lgen > 0[Err] 1054 - Unknown column 'projects.Lgen' in 'where clause'
-
I would like to display a random quote(text) in a fixed position in relation to my header graphic (the text would be on top of the graphic). To further complicate the situation the header graphic is inside of a centered table on the page. I think the answer will be some combination of java and css but I'm not sure where to go for the solution. Any ideas or places to look?
-
Thank you for the striaght forward and simple solution Scott
-
Thanks all - I will go look for javascript solution.
-
I would like to create a list which, when an item is clicked, expands to show additional text regarding the item. Then if another list item is clicked, the previous text would collapse and the current items descriptive text would be shown.Is this possible with CSS? or can someone point me in the right direction.
Google maps - can I create an url to a My Maps + 1 location
in HTML/XHTML
Posted