Re: [U2] Proposed MVDBMS forum to replace CDP
Take out the "nospam.please" On Thu, 29 Dec 2011, Kate Stanton wrote: > Oops! Google Chrome could not find nospam.pleasenebula-rnd.com > On 29 December 2011 09:33, Tony Gravagno <3xk547...@sneakemail.com> wrote: > > > For anyone familiar with comp.databases.pick, a migration > > initiative is under way to a new community owned and moderated > > forum. You are welcome to get information and links from my > > blog, to provide your own feedback, and to join the new group for > > vendor-independent, cross-platform discussions. CDP occasionally > > gets U2-specific questions and it would be nice to bring back U2 > > representation to that audience. > > > > > > > > This U2 forum has a long history as a successfully moderated > > e-mail group. The only two concerns from the CDP so far are 1) > > people don't want to let go of Usenet, and 2) they're concerned > > about moderation turning into censorship. Your responses to > > those concerns are most appreciated. I welcome U2 forum > > moderators and other community leaders to lend their name and > > assistance to help ensure the credibility of the new forum. > > > > As PickWiki is a platform-independent resource, of value to > > everyone in this industry, I hope that we can re-invigorate the > > new MVDBMS Google Group to be a similar asset for everyone. > > > > Happy and Safe New Year to all! > > > > Tony Gravagno > > Nebula Research and Development > > TG@ remove.pleaseNebula-RnD.com > > remove.pleaseNebula-RnD.com/blog > > Visit PickWiki.com! Contribute! > > http://Twitter.com/TonyGravagno > > NEW! http://groups.google.com/group/mvdbms/about > > > > ___ > > U2-Users mailing list > > U2-Users@listserver.u2ug.org > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > > > > -- > Kate Stanton > Walstan Systems Ltd > 4 Kelmarna Ave, Herne Bay, Auckland 1011, New Zealand > Phone: + 64 9 360 5310 Mobile: + 64 21 400 486 > Email: k...@walstan.com > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > > Regards, Bob Rasmussen, President, Rasmussen Software, Inc. personal e-mail: r...@anzio.com company e-mail: r...@anzio.com voice: (US) 503-624-0360 (9:00-6:00 Pacific Time) fax: (US) 503-624-0760 web: http://www.anzio.com street address: Rasmussen Software, Inc. 10240 SW Nimbus, Suite L9 Portland, OR 97223 USA ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Proposed MVDBMS forum to replace CDP
Oops! Google Chrome could not find nospam.pleasenebula-rnd.com On 29 December 2011 09:33, Tony Gravagno <3xk547...@sneakemail.com> wrote: > For anyone familiar with comp.databases.pick, a migration > initiative is under way to a new community owned and moderated > forum. You are welcome to get information and links from my > blog, to provide your own feedback, and to join the new group for > vendor-independent, cross-platform discussions. CDP occasionally > gets U2-specific questions and it would be nice to bring back U2 > representation to that audience. > > > > This U2 forum has a long history as a successfully moderated > e-mail group. The only two concerns from the CDP so far are 1) > people don't want to let go of Usenet, and 2) they're concerned > about moderation turning into censorship. Your responses to > those concerns are most appreciated. I welcome U2 forum > moderators and other community leaders to lend their name and > assistance to help ensure the credibility of the new forum. > > As PickWiki is a platform-independent resource, of value to > everyone in this industry, I hope that we can re-invigorate the > new MVDBMS Google Group to be a similar asset for everyone. > > Happy and Safe New Year to all! > > Tony Gravagno > Nebula Research and Development > TG@ remove.pleaseNebula-RnD.com > remove.pleaseNebula-RnD.com/blog > Visit PickWiki.com! Contribute! > http://Twitter.com/TonyGravagno > NEW! http://groups.google.com/group/mvdbms/about > > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > -- Kate Stanton Walstan Systems Ltd 4 Kelmarna Ave, Herne Bay, Auckland 1011, New Zealand Phone: + 64 9 360 5310 Mobile: + 64 21 400 486 Email: k...@walstan.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] MS-SQL Question
You can't use the Column alias directly in a where cause, you need to put in a derived dataset (table) i.e. SELECT * FROM ( SELECT substring(colname ,charindex('|',colname)+1, charindex('|',colname, charindex('|',colname)+1) - charindex('|',colname) -1) as "PID" FROM SomeTable ) as DerivedTable WHERE DerivedTable.PID = something Don Verhagen www.REMOVEemjackTHIS.com > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of George Gallen > Sent: Wednesday, December 28, 2011 3:38 PM > To: U2 Users List > Subject: Re: [U2] MS-SQL Question > > It came back with unknown column error. I'll have to play with it > again, it's possible I typed something wrong, > But at least for now, it's working the other way I set it up. > > Thanks > George > > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of George Gallen > Sent: Thursday, 29 December 2011 2:51 AM > To: U2 Users > Subject: [U2] MS-SQL Question > > I'm querying a sequel server , I have a column in one table that the > data is in the form of "X|Y|Z". > > I have the following in my SELECT: > > substring(colname ,charindex('|',colname)+1, charindex('|',colname, > charindex('|',colname)+1) - charindex('|',colname) -1) as "PID" > > Is there anyway that I can then use the "PID" designation in a where > clause, without having to retype the string again? > > > I can't add a virtual column to the table , and I can't add a procedure > either. > > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] MS-SQL Question
It came back with unknown column error. I'll have to play with it again, it's possible I typed something wrong, But at least for now, it's working the other way I set it up. Thanks George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Jordan Sent: Wednesday, December 28, 2011 3:35 PM To: U2 Users List Subject: Re: [U2] MS-SQL Question You created PID as a synonym in the SELECT statement, you should be able to use it in the where clause. I am sure I have done that before in the past with SQL Server. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Thursday, 29 December 2011 7:09 AM To: U2 Users List Subject: Re: [U2] MS-SQL Question That didn't work because it is not a virtual column defined in the table layout. What I did was Created a variable in my program that contained the full string, and when I was creating the SQL String to pass to the server, I used the variable name instead. It worked in the sense, I didn't have to retype the string multiple times, but the SQL query that Was passed to the MSSQL machine did have it multiple times still, but at least it's more manageable >From a programming standpoint, where I only have to make changes to one spot. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Jordan Sent: Wednesday, December 28, 2011 3:04 PM To: U2 Users List Subject: Re: [U2] MS-SQL Question You should be able to just use "PID" in the where clause. David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Thursday, 29 December 2011 2:51 AM To: U2 Users Subject: [U2] MS-SQL Question I'm querying a sequel server , I have a column in one table that the data is in the form of "X|Y|Z". I have the following in my SELECT: substring(colname ,charindex('|',colname)+1, charindex('|',colname, charindex('|',colname)+1) - charindex('|',colname) -1) as "PID" Is there anyway that I can then use the "PID" designation in a where clause, without having to retype the string again? I can't add a virtual column to the table , and I can't add a procedure either. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] MS-SQL Question
You created PID as a synonym in the SELECT statement, you should be able to use it in the where clause. I am sure I have done that before in the past with SQL Server. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Thursday, 29 December 2011 7:09 AM To: U2 Users List Subject: Re: [U2] MS-SQL Question That didn't work because it is not a virtual column defined in the table layout. What I did was Created a variable in my program that contained the full string, and when I was creating the SQL String to pass to the server, I used the variable name instead. It worked in the sense, I didn't have to retype the string multiple times, but the SQL query that Was passed to the MSSQL machine did have it multiple times still, but at least it's more manageable >From a programming standpoint, where I only have to make changes to one spot. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Jordan Sent: Wednesday, December 28, 2011 3:04 PM To: U2 Users List Subject: Re: [U2] MS-SQL Question You should be able to just use "PID" in the where clause. David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Thursday, 29 December 2011 2:51 AM To: U2 Users Subject: [U2] MS-SQL Question I'm querying a sequel server , I have a column in one table that the data is in the form of "X|Y|Z". I have the following in my SELECT: substring(colname ,charindex('|',colname)+1, charindex('|',colname, charindex('|',colname)+1) - charindex('|',colname) -1) as "PID" Is there anyway that I can then use the "PID" designation in a where clause, without having to retype the string again? I can't add a virtual column to the table , and I can't add a procedure either. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Proposed MVDBMS forum to replace CDP
For anyone familiar with comp.databases.pick, a migration initiative is under way to a new community owned and moderated forum. You are welcome to get information and links from my blog, to provide your own feedback, and to join the new group for vendor-independent, cross-platform discussions. CDP occasionally gets U2-specific questions and it would be nice to bring back U2 representation to that audience. This U2 forum has a long history as a successfully moderated e-mail group. The only two concerns from the CDP so far are 1) people don't want to let go of Usenet, and 2) they're concerned about moderation turning into censorship. Your responses to those concerns are most appreciated. I welcome U2 forum moderators and other community leaders to lend their name and assistance to help ensure the credibility of the new forum. As PickWiki is a platform-independent resource, of value to everyone in this industry, I hope that we can re-invigorate the new MVDBMS Google Group to be a similar asset for everyone. Happy and Safe New Year to all! Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com remove.pleaseNebula-RnD.com/blog Visit PickWiki.com! Contribute! http://Twitter.com/TonyGravagno NEW! http://groups.google.com/group/mvdbms/about ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] MS-SQL Question
That didn't work because it is not a virtual column defined in the table layout. What I did was Created a variable in my program that contained the full string, and when I was creating the SQL String to pass to the server, I used the variable name instead. It worked in the sense, I didn't have to retype the string multiple times, but the SQL query that Was passed to the MSSQL machine did have it multiple times still, but at least it's more manageable >From a programming standpoint, where I only have to make changes to one spot. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Jordan Sent: Wednesday, December 28, 2011 3:04 PM To: U2 Users List Subject: Re: [U2] MS-SQL Question You should be able to just use "PID" in the where clause. David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Thursday, 29 December 2011 2:51 AM To: U2 Users Subject: [U2] MS-SQL Question I'm querying a sequel server , I have a column in one table that the data is in the form of "X|Y|Z". I have the following in my SELECT: substring(colname ,charindex('|',colname)+1, charindex('|',colname, charindex('|',colname)+1) - charindex('|',colname) -1) as "PID" Is there anyway that I can then use the "PID" designation in a where clause, without having to retype the string again? I can't add a virtual column to the table , and I can't add a procedure either. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] MS-SQL Question
You should be able to just use "PID" in the where clause. David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Thursday, 29 December 2011 2:51 AM To: U2 Users Subject: [U2] MS-SQL Question I'm querying a sequel server , I have a column in one table that the data is in the form of "X|Y|Z". I have the following in my SELECT: substring(colname ,charindex('|',colname)+1, charindex('|',colname, charindex('|',colname)+1) - charindex('|',colname) -1) as "PID" Is there anyway that I can then use the "PID" designation in a where clause, without having to retype the string again? I can't add a virtual column to the table , and I can't add a procedure either. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] MS-SQL Question
I'm querying a sequel server , I have a column in one table that the data is in the form of "X|Y|Z". I have the following in my SELECT: substring(colname ,charindex('|',colname)+1, charindex('|',colname, charindex('|',colname)+1) - charindex('|',colname) -1) as "PID" Is there anyway that I can then use the "PID" designation in a where clause, without having to retype the string again? I can't add a virtual column to the table , and I can't add a procedure either. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users