Ask a Question related to Dreamweaver AppDev, Design and Development.
-
Kory #1
Data Type Missmatch?????
I keep getting a data type missmatch error when testing the following SQL
statement. I can't figure out what is wrong with it. All fields have
matching data types.
SELECT StateName FROM USStates WHERE StateID IN (SELECT StateID FROM
RepStates WHERE RepID IN (SELECT RepID
FROM SalesRep
WHERE RepID = 'record1'))
Thanks, Kory
Kory Guest
-
Paths missmatch - Help please
So let me explain the case: in MXI file I have this row: <file name="someFile.htm" destination="$dreamweaver/Configuration/Commands" /> When... -
Converting from data type varchar to data type money
Hi all, Tearing my hair out trying to figure this out. If anyone can provide any help i would greatly appreciate it. When I try to do an insert... -
Converting data type varchar to data type money
Hi all, Tearing my hair out trying to figure this out. If anyone can provide any help i would greatly appreciate it. When I try to do an insert... -
Type Missmatch error
My problem is i have created a Com(in vb ) which assept a MSXML2.DOMDocument as parameter Public Sub InsBudgetVirement(xmlDocs As... -
HowTo Send Uploaded File with INPUT Type file to Sql Server Image Data Type
I have the following problem: I have the following form client side: <FORM.......> <FORM action="./WZUpload.asp" method="Post"... -
Singularity.co.uk #2 Re: Data Type Missmatch?????
Kory
Is RepID a numerice field?
Brendan
"Kory" <kory@c5designs.com> wrote in message
news:d0n5tj$mp5$1@forums.macromedia.com...> I keep getting a data type missmatch error when testing the following SQL
> statement. I can't figure out what is wrong with it. All fields have
> matching data types.
>
> SELECT StateName FROM USStates WHERE StateID IN (SELECT StateID FROM
> RepStates WHERE RepID IN (SELECT RepID
> FROM SalesRep
> WHERE RepID = 'record1'))
>
> Thanks, Kory
>
>
Singularity.co.uk Guest
-
Kory #3 Re: Data Type Missmatch?????
Yes!
"Singularity.co.uk" <Brendan.Collins@RemoveThisSingularity.co.uk> wrote in
message news:d0n8co$quj$1@forums.macromedia.com...> Kory
>
> Is RepID a numerice field?
>
> Brendan
>
> "Kory" <kory@c5designs.com> wrote in message
> news:d0n5tj$mp5$1@forums.macromedia.com...>>> I keep getting a data type missmatch error when testing the following SQL
>> statement. I can't figure out what is wrong with it. All fields have
>> matching data types.
>>
>> SELECT StateName FROM USStates WHERE StateID IN (SELECT StateID FROM
>> RepStates WHERE RepID IN (SELECT RepID
>> FROM SalesRep
>> WHERE RepID = 'record1'))
>>
>> Thanks, Kory
>>
>>
>
Kory Guest
-
Singularity.co.uk #4 Re: Data Type Missmatch?????
Kory
Then I take it that record1 is a parameter? Try removing the single quotes
around record1 as follows:
SELECT StateName
FROM USStates
WHERE StateID IN
(SELECT StateID
FROM RepStates
WHERE RepID IN
(SELECT RepID
FROM SalesRep
WHERE RepID = record1))
Brendan
"Kory" <kory@c5designs.com> wrote in message
news:d0n8q0$rls$1@forums.macromedia.com...SQL> Yes!
>
> "Singularity.co.uk" <Brendan.Collins@RemoveThisSingularity.co.uk> wrote in
> message news:d0n8co$quj$1@forums.macromedia.com...> > Kory
> >
> > Is RepID a numerice field?
> >
> > Brendan
> >
> > "Kory" <kory@c5designs.com> wrote in message
> > news:d0n5tj$mp5$1@forums.macromedia.com...> >> I keep getting a data type missmatch error when testing the following>> >> >> statement. I can't figure out what is wrong with it. All fields have
> >> matching data types.
> >>
> >> SELECT StateName FROM USStates WHERE StateID IN (SELECT StateID FROM
> >> RepStates WHERE RepID IN (SELECT RepID
> >> FROM SalesRep
> >> WHERE RepID = 'record1'))
> >>
> >> Thanks, Kory
> >>
> >>
> >
>
Singularity.co.uk Guest
-
Kory #5 Re: Data Type Missmatch?????
That did it!
Maybe you can tell what is wrong with this one!
I am trying to display all states that are not already associated with the
repID. So I want to exclude states that are already associated with the
repid
SELECT * FROM USStates WHERE StateID <> (SELECT *
FROM RepStates
WHERE RepID = record1)
ORDER BY StateName ASC
"Singularity.co.uk" <Brendan.Collins@RemoveThisSingularity.co.uk> wrote in
message news:d0na0l$gg$1@forums.macromedia.com...> Kory
>
> Then I take it that record1 is a parameter? Try removing the single quotes
> around record1 as follows:
>
> SELECT StateName
> FROM USStates
> WHERE StateID IN
> (SELECT StateID
> FROM RepStates
> WHERE RepID IN
> (SELECT RepID
> FROM SalesRep
> WHERE RepID = record1))
>
> Brendan
>
> "Kory" <kory@c5designs.com> wrote in message
> news:d0n8q0$rls$1@forums.macromedia.com...> SQL>> Yes!
>>
>> "Singularity.co.uk" <Brendan.Collins@RemoveThisSingularity.co.uk> wrote
>> in
>> message news:d0n8co$quj$1@forums.macromedia.com...>> > Kory
>> >
>> > Is RepID a numerice field?
>> >
>> > Brendan
>> >
>> > "Kory" <kory@c5designs.com> wrote in message
>> > news:d0n5tj$mp5$1@forums.macromedia.com...
>> >> I keep getting a data type missmatch error when testing the following>>>>> >> statement. I can't figure out what is wrong with it. All fields have
>> >> matching data types.
>> >>
>> >> SELECT StateName FROM USStates WHERE StateID IN (SELECT StateID FROM
>> >> RepStates WHERE RepID IN (SELECT RepID
>> >> FROM SalesRep
>> >> WHERE RepID = 'record1'))
>> >>
>> >> Thanks, Kory
>> >>
>> >>
>> >
>> >
>>
>
Kory Guest
-
Julian Roberts #6 Re: Data Type Missmatch?????
Use NOT IN instead of IN
--
Jules
[url]http://www.charon.co.uk/charoncart[/url]
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004
Julian Roberts Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
