Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
group the query result
Thx for quick response. When you say 'UGLY' you mean the sql is big and slow? If this is possible then can you show me the sample code based on my original sql statement? Here is what I'm doing for this. I'm executing the sql in servlet and put the results into context and pass to velocity...- cfmx
- Post #3
- Forum: Oracle: All versions
-
group the query result
Hi all, I have this sql string select tt.ENTRYID, tt.PROJECT, tt.DEVELOPER, tt.TASK, tt.DESCRIPTION, to_char(tt.WORKDATE, 'MM/DD/YYYY') as WORKDATE, tt.DURATION, tt.MILEAGE, p.PROJECTNAME, u.USERNAME from TIMETRACKER tt...- cfmx
- Thread
- Replies: 2
- Forum: Oracle: All versions
-
String can not have break line?
Thank you for quick response. However, I need more help if you can help me. I know that String sqlStr = "select name " + "from tableA " + "where name = '" + username + "'"; is the only way to make work on sql string. My... -
String can not have break line?
I'm very familiar with Coldfusion language and now trying to learn Java. Java gives me so much headache... I have a question about sql string. Is there way to read this kind of query from the java? Of course java throws the error here but I'm hoping that there's way to parse this sql string...
