PERFECT! Thanks Puneet!
Mr. Puneet Kishor-2 wrote:
>
>
> On Apr 18, 2012, at 11:20 PM, starvingpilot wrote:
>
>>
>>
>>
>> Puneet Kishor-2 wrote:
>>>
>>>
>>> On Apr 18, 2012, at 11:10 PM, starvingpilot wrote:
>
Puneet Kishor-2 wrote:
>
>
> On Apr 18, 2012, at 11:10 PM, starvingpilot wrote:
>
>>
>> Here's a query that works
>>
>> sqlStatement = [NSString stringWithFormat:@"SELECT * FROM stations WHERE
>> state like '%@ %'",theS
Here's a query that works
sqlStatement = [NSString stringWithFormat:@"SELECT * FROM stations WHERE
state like '%@ %'",theState]; <--- this yields a result: 0
sqlStatement = [NSString stringWithFormat:@"SELECT state, power || ' kW'
power FROM (SELECT state, Cast(Rtrim(power, 'kW') AS 'numeric')
one last thing, sorry to be such a pain... how can I search for a specific
state? Right now it's listing ALL the states, I need to list from a
specific state like "CA"
--
View this message in context:
http://old.nabble.com/trim-alpha-numeric-string-so-it%27s-numeric-cast-then-order-tp33711898p3
disregard, so the query works on sqlite terminal, just not on my app. Thanks
for the help, ill work on it from here... cheers!
--
View this message in context:
http://old.nabble.com/trim-alpha-numeric-string-so-it%27s-numeric-cast-then-order-tp33711898p33711989.html
Sent from the SQLite mailing
I actually did have the parenthesis there... I didnt copy and paste the last
one. It was there however and I am still having problems
--
View this message in context:
http://old.nabble.com/trim-alpha-numeric-string-so-it%27s-numeric-cast-then-order-tp33711898p33711982.html
Sent from the SQLite
Also, I need to select from a specific state like "CA" Where is that part in
the query?
--
View this message in context:
http://old.nabble.com/trim-alpha-numeric-string-so-it%27s-numeric-cast-then-order-tp33711898p33711973.html
Sent from the SQLite mailing list archive at Nabble.com.
_
Thanks for the quick reply Puneet. However I had a syntax error on App as
well as when I typed that query on my sqlite browser. Here's my syntax
"SELECT state, power || ' kW' power FROM (SELECT state, Cast(Rtrim(power,
'kW') AS 'numeric') power FROM stations ORDER BY power"
table: stations
fiel
Greetings! I am currently working on an iOS app and not too well versed in
SQLite. Here's what I am trying to do.
I have a table "stations" and the fields "state" populated by US States and
"power" which is populated with strings similar to 1.0 kW, 50.0 kW 10.0 kW
etc...
so the query I need...
9 matches
Mail list logo