CodeCharge Studio
search Register Login  

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> CodeCharge.Discussion

 Error on using the "Label" type with "Join"

Print topic Send  topic

Author Message
phantom
Posted: 02/09/2001, 5:54 PM

I can someone confirm if this is possible, or is it a bug? as I am unable to
get this to work.

Basically, I need to "Label" a field, but "join" the tables (from the
properties setting of label), but for some reason on the ASP coding it
delivers the following error when I excute it.

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Type mismatch in expression.

/specs/Common.asp, line 31


Thanks
Phantom




Joachim Uersfeld
Posted: 02/09/2001, 8:04 PM

What reasons? In my projects every join works without problems. All tables
have a unique ID-Field (integer). An example of the adjustments in CC /
Join: Table = product, Primary Key = productID, Showing = ProductName. And
CC is showing the productName. Check your settings.

Joachim


"phantom" <pahntom@phantom.com> schrieb im Newsbeitrag
news:9626vr$qep$1@news.codecharge.com...
> I can someone confirm if this is possible, or is it a bug? as I am unable
to
> get this to work.
>
> Basically, I need to "Label" a field, but "join" the tables (from the
> properties setting of label), but for some reason on the ASP coding it
> delivers the following error when I excute it.
>
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> [Microsoft][ODBC Microsoft Access Driver] Type mismatch in expression.
>
> /specs/Common.asp, line 31
>
>
> Thanks
> Phantom
>
>
>
>
>

phantom
Posted: 02/09/2001, 8:15 PM

Thanks.

But have you set the field to "Label" ??? With other fields like List Box,
Text Box it all works fine!!! with No Errors!

I just installed v1.103, and same problem exits. Is this a limiation of the
program? string of ASP??? or what???

Thanks



"Joachim Uersfeld" <uersfeld@pc-team.de> wrote in message
news:962ekj$7k7$1@news.codecharge.com...
> What reasons? In my projects every join works without problems. All
tables
> have a unique ID-Field (integer). An example of the adjustments in CC /
> Join: Table = product, Primary Key = productID, Showing = ProductName. And
> CC is showing the productName. Check your settings.
>
> Joachim
>
>
> "phantom" <pahntom@phantom.com> schrieb im Newsbeitrag
>news:9626vr$qep$1@news.codecharge.com...
> > I can someone confirm if this is possible, or is it a bug? as I am
unable
> to
> > get this to work.
> >
> > Basically, I need to "Label" a field, but "join" the tables (from the
> > properties setting of label), but for some reason on the ASP coding it
> > delivers the following error when I excute it.
> >
> > Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> > [Microsoft][ODBC Microsoft Access Driver] Type mismatch in expression.
> >
> > /specs/Common.asp, line 31
> >
> >
> > Thanks
> > Phantom
> >
> >
> >
> >
> >
>
>

Joachim Uersfeld
Posted: 02/10/2001, 7:14 AM

I use Listboxes (in the RecordForm) and Labels (in the GridForm), all with
ASP and Templates. Which fieldtype and fieldName (better the structure of
the join-table) make problems?

Joachim


"phantom" <pahntom@phantom.com> schrieb im Newsbeitrag
news:962f89$8ob$1@news.codecharge.com...
> Thanks.
>
> But have you set the field to "Label" ??? With other fields like List Box,
> Text Box it all works fine!!! with No Errors!
>
> I just installed v1.103, and same problem exits. Is this a limiation of
the
> program? string of ASP??? or what???
>
> Thanks
>
>
>
> "Joachim Uersfeld" <uersfeld@pc-team.de> wrote in message
>news:962ekj$7k7$1@news.codecharge.com...
> > What reasons? In my projects every join works without problems. All
> tables
> > have a unique ID-Field (integer). An example of the adjustments in CC /
> > Join: Table = product, Primary Key = productID, Showing = ProductName.
And
> > CC is showing the productName. Check your settings.
> >
> > Joachim
> >
> >
> > "phantom" <pahntom@phantom.com> schrieb im Newsbeitrag
> >news:9626vr$qep$1@news.codecharge.com...
> > > I can someone confirm if this is possible, or is it a bug? as I am
> unable
> > to
> > > get this to work.
> > >
> > > Basically, I need to "Label" a field, but "join" the tables (from the
> > > properties setting of label), but for some reason on the ASP coding it
> > > delivers the following error when I excute it.
> > >
> > > Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> > > [Microsoft][ODBC Microsoft Access Driver] Type mismatch in expression.
> > >
> > > /specs/Common.asp, line 31
> > >
> > >
> > > Thanks
> > > Phantom
> > >
> > >
> > >
> > >
> > >
> >
> >
>
>

CodeCharge
Posted: 02/11/2001, 6:59 PM

You may want to emailsupport@codecharge.com , possibly with your project
file.

phantom <pahntom@phantom.com> wrote in message
news:9626vr$qep$1@news.codecharge.com...
> I can someone confirm if this is possible, or is it a bug? as I am unable
to
> get this to work.
>
> Basically, I need to "Label" a field, but "join" the tables (from the
> properties setting of label), but for some reason on the ASP coding it
> delivers the following error when I excute it.
>
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> [Microsoft][ODBC Microsoft Access Driver] Type mismatch in expression.
>
> /specs/Common.asp, line 31
>
>
> Thanks
> Phantom
>
>
>
>
>


   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by UltraApps.com  and YesSoftware, Inc.