Ideally, you would want want more stored procedures so that changes are
easier to make then tracking down all of the ad hoc cfquery statements.
Again, the word ideally.
Teddy
On 9/28/06, Andrew Scott <[EMAIL PROTECTED]> wrote:
>
> Very Strange,
>
> I use select * from all the time when I need all the columns and never
> have
> a run into this problem. I would be asking this thought how about a sample
> of the code in question, are you using cachedwithin? If so then you need
> to
> remove that or find a way to rerun the cached query.
>
> It is very vauge on the question, and after using all versions of cf from
> 2.0 - 7.02 this is the first time I have seen this problem, but also what
> DB
> are you using, as suggested you might need to flush the DB Connection.
>
>
>
>
> On 9/28/06, Scott Stroz <[EMAIL PROTECTED]> wrote:
> >
> > By any chance, are there any <cfqueryparam>s in the WHERE clause? I
> have
> > seen issues similar to what you describe with using 'select * from...'
> and
> > <cfqueryparam>.
> >
> > On 9/27/06, Brent Shaub <[EMAIL PROTECTED]> wrote:
> > >
> > > Teddy, I was hoping that'd be the answer, but it's not. Doesn't seem
> to
> > > affect anything relevant to the queries. There must be something
> > because if
> > > I add a column to the table with a star, I got an error "value cannot
> be
> > > converted to the requested type". I changed the query to add a static
> > value
> > > ('x' as temp) and it ran fine. Then I took out the static field, and
> it
> > ran
> > > fine. Thus, I believe it's something to do with the way CF is caching
> > the
> > > query. Does it matter this query is in a .cfc that is an
> > application-level
> > > object with a "get" function that runs a star query? I'm thinking
> it's
> > the
> > > star regardless of CF-implementation.
> > >
> > > Any help appreciated.
> > >
> > > Brent
> > >
> > >
> >
> >
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254593
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
