It's an old-school bass synthesizer. (yeah, I'd love to get my hands on one
too...)
veering blindly off-topic,
Jamie
--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC 28270
www.solutionmasters.com
704.563.5559 x 228 Voice
704.849.9291 Fax
-----Original Message-----
From: Chapman, Katrina <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Thursday, August 17, 2000 3:01 PM
Subject: RE: SQL query problem...
>What's a TB303?
>
>--K
>
>-----Original Message-----
>From: Rich Wild [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, August 17, 2000 10:57 AM
>To: [EMAIL PROTECTED]
>Subject: RE: SQL query problem...
>
>
>
>OK, this is probably wrong, but its all I can glean from SQL BOL
>
>ALTER TABLE table_name NOCHECK CONSTRAINT your_primary_key
>
>...do your stuff...
>
>ALTER TABLE table_name CHECK CONSTRAINT your_primary_key
>
>
>
>If I'm right, you owe me a mint condition TB303!
>
>*me sits down and crosses fingers in hope*
>
>--
>Rich Wild
>Senior Web Designer
>
>-------------------------------------------------------
>e-mango.com ltd Tel: 01202 587 400
>Lansdowne Place Fax: 01202 587 401
>17 Holdenhurst Road
>Bournemouth Mailto:[EMAIL PROTECTED]
>BH8 8EW, UK http://www.e-mango.com
>-------------------------------------------------------
>This message may contain information which is legally
>privileged and/or confidential. If you are not the
>intended recipient, you are hereby notified that any
>unauthorised disclosure, copying, distribution or use
>of this information is strictly prohibited. Such
>notification notwithstanding, any comments, opinions,
>information or conclusions expressed in this message
>are those of the originator, not of e-mango.com ltd,
>unless otherwise explicitly and independently indicated
>by an authorised representative of e-mango.com ltd.
>-------------------------------------------------------
>
>
>-----Original Message-----
>From: Ryan Williams [mailto:[EMAIL PROTECTED]]
>Sent: 17 August 2000 18:15
>To: [EMAIL PROTECTED]
>Subject: Re: SQL query problem...
>
>
>
>
>
> Oops. I just stumbled onto the answer by accident. I just removed the
>"-2"
> and
> associated parentheses from the sub-query and I got my results. My
> sub-query
> now looks like:
> select max(right(wire_id,len(wire_id))) from wire_list)
> and it works too !! :-)
>
> My sincerest apologies to everyone in the list.
>
> Ryan Williams
> [EMAIL PROTECTED]
>
>
>
>> ----- Original Message -----
>> From: "Ryan Williams" <[EMAIL PROTECTED]>
>> To: <[EMAIL PROTECTED]>
>> Sent: Thursday, August 17, 2000 12:45 PM
>> Subject: SQL query problem...
>>
>>
>> > I have a SQL problem. I know what information I want to retrieve
>from
>> > the DB,
>> > however, I do not know what precisely is the proper SQL syntax/function
>> is
>> > in order to
>> > achieve it.
>> >
>> > The query as it is currently written in my CF template is:
>> > select wl.*,p.*,wlg.*,wb.*,wsnd.*,wrcvd.*,ws.*
>> > from wire_list wl
>> > left join P_officers p on wl.reg_by = p.off_id
>> > left join wire_status ws on wl.status_code = ws.status_code
>> > left join wire_log wlg on wl.wire_id = wlg.wire_id
>> > left join wire_senders wsnd on wl.sender_id = wsnd.sender_id
>> > left join wire_rcv_modes wrcvd on wl.rcv_mode = wrcvd.rcv_mode
>> > left join wire_banks wb on wl.bank_id = wb.bank_id
>> > where wl.wire_id = (
>> > select max(right(wire_id,(len(wire_id)-2)))
>> > from wire_list)
>> >
>> > The error this code generates when I attempt to run it in SQL query
>> > analyzer:
>> > Server: Msg 536, Level 16, State 1, Line 1
>> > Invalid length parameter passed to the substring function.
>> >
>> > The content of the wire_id column looks like this format:
>> > ab999 and is of varchar datatype.
>> >
>> > I did not code these tables and I am in the middle of re-coding the
>> > entire site to be FuseBox compliant. I am trying to select the top
>(max)
>> > wire_id from the wire_list table, and display all records related
>> > to the returned value of the max function, but the result that
>> areretrieved
>> > to date,
>> > with the code "Select max(wire_id)" and no WHERE clause,
>> > is ab99 when I know there are wire_id's in the table that have values
>> > of ab999, etc. It seems that SQL does not recognize that ab999 is the
>> > larger value when compared to ab99.
>> >
>> > The solution I am trying to apply with the code at the top of this
email
>> is
>> > to "get"
>> > the "number" part of the wire_id column, minus the two letters, and
then
>> use
>> > the max function on
>> > the remainder to get the ab999 wire_id i know is in the table. I
looked
>> > through the
>> > SQL books online and it seems that SQL Sever does not have the ability
>to
>> > convert
>> > the varchar datatype (of the wire_id) column to the int data type that
>> > the max function seems to need in order to work properly.
>> >
>> > Does anyone know of a work around for this problem? Or am I going
>totally
>> > in the wrong
>> > direction with this logic?
>> >
>> > Any help/ideas/comments would be greatly appreciated. Thanks.
>> >
>> > Ryan Williams
>> > [EMAIL PROTECTED]
>> >
>>
> -------------------------------------------------------------------------
>> --
>> > ---
>> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>> > To Unsubscribe visit
>> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
>or
>> > send a message to [EMAIL PROTECTED] with 'unsubscribe'
>in
>> > the body.
>> >
>> >
>>
>>
>
>---------------------------------------------------------------------------
-
>--
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
>---------------------------------------------------------------------------
-
>--
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
>---------------------------------------------------------------------------
---
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
