|
|
 |
| found 24 articles for 0.303 sec |
  |
| I've been trying this but all I'm getting is generic error mssg. that doesn't
tell me anything helpful. I'll keep working on it.
<cfquery datasource="#dsn#" name="GetWell">
Select Hour, Date, Time, CasingP, TubingP, Choke, SepP, StaticP, DiffP, TempF,
Orifice, GasRate, CumGas, CondGain, CondRate, CumCond, H2oGain, H2oRate,
CumH2o, OriginalLoad, SandShk, Comments, BattV, ChargeV
From #WellID# |
|
 |
|
 |
Group: macromedia.coldfusion.database_access · Group Profile · Search for Hour1 in macromedia.coldfusion.database_access
Author: InkFasT!
Date: Aug 7, 2008 14:02
You need to add a field to your query that combines Year and Week. Then Group and Order on that. SELECT.... Year(TABLE.DATE) & Format(Table.Week,"00") As YearWeek ..... GROUP BY TABLE.NAME, Year(TABLE.DATE) & Format(Table.Week,"00") ORDER BY Year(TABLE.DATE) & Format(Table.Week,"00"); -- HTH, George "Art Vandaley" <kestafir@hotmail.com> wrote in message news:OiP39kcUIHA.484@TK2MSFTNGP06
|
| Show full article (1.53Kb) · Show article thread |
|
|
|
1 ·
2 ·
3 ·
next |
|
|
