Re: [sqlite] IF...THEN constructs

nice work! Stephen Oberholtzer wrote: > On Wed, Feb 27, 2008 at 6:00 PM, Jason Salas <[EMAIL PROTECTED]> wrote: > >> Hi Igor, >> >> Thanks for the insight. I'm used to doing stored procedures for web >> apps, which conditionally execute statements ba

Re: [sqlite] IF...THEN constructs

shoot. worst suspicions affirmed. :-) although this is for a C# console app, it's still largely client/server and i designed the back-end as such, to reduce roundtrips to the DB. no sweat, a little refactoring won't hurt. thanks again! Igor Tandetnik wrote: > Jason Salas <[EMAIL PRO

Re: [sqlite] IF...THEN constructs

wrote: > "Jason Salas" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > >> I'm used to doing lengthy T-SQL programming in SQL Server, so this is >> kinda new to me. How does one replicate doing IF...THEN conditional >> blocks in SQLite 3?

[sqlite] IF...THEN constructs

Hi everyone, I'm used to doing lengthy T-SQL programming in SQL Server, so this is kinda new to me. How does one replicate doing IF...THEN conditional blocks in SQLite 3? Is it all nested CASE statements within the SQL statement(s)? Or should I figure out the logic in my client (web,

Re: [sqlite] Concatenating values from multiple varchar fields

Never mind folks...I got it! Double-pipes does the trick! "||" lastName || ', ' || firstName as [name] from myTable Awesome. Admittedly confusing at first glance, but awesome. :-) Jason Salas wrote: > I'm new to SQLite, coming over from SQL Server. I often do string > co

[sqlite] Concatenating values from multiple varchar fields

I'm new to SQLite, coming over from SQL Server. I often do string concatenation like so: lastName + ', ' + firstName as [name] from myTable But it tries to run a math computation and returns '0.0' for each field. I've tried some other concat operators that I know of, but none work. How is