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
>
>
>
>
>
|
|
|
|