Unknown column 'my column' in 'field list'

[Eric Browning-3]

Lasso 8.5.6 on 10.5 server

I recently added 8 fields to an existing database and went through the  
lasso settings and confirmed that the new fields do indeed show up in  
Datasources > fields for this database.  I have checked my code and  
the fields are spelled correctly (including case) in the inline and in  
the html code itself.  I have also restarted the webserver running  
lasso to no avail and I can update those new fields using the database  
browser so it's not a mysql thing.  Any ideas?

Thanks in advance :-)
--
Eric Browning

--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/Lasso/Browse/
Manage your subscription: http://www.ListSearch.com/Lasso/

[Jolle Carlestam-3]

6 nov 2009 kl. 06.00 skrev Eric Browning:

> Lasso 8.5.6 on 10.5 server
>
> I recently added 8 fields to an existing database and went through the
> lasso settings and confirmed that the new fields do indeed show up in
> Datasources > fields for this database.  I have checked my code and
> the fields are spelled correctly (including case) in the inline and in
> the html code itself.  I have also restarted the webserver running
> lasso to no avail and I can update those new fields using the database
> browser so it's not a mysql thing.  Any ideas?

It is a Mysql thing. The error message is sent from Mysql. You  
probably have a syntax error that causes the error. Try to insert  
action_statement inside the inline container. That will show you the  
exact query sent to Mysql. Copy it and use it with Mysql directly.  
Either in the Lasso DatabaseBrowsers SQL window, on the command line  
or using your favorite Mysql interface.
You'll get the same error and probably by examining the query can  
figure out why it isn't working.

HDB
Jolle


--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/Lasso/Browse/
Manage your subscription: http://www.ListSearch.com/Lasso/

[Eric Browning-3]

IDK it was weirdness I tell ya.  I erased the field from MySQL and  
created another one named differently and it's fine now.  To satisfy  
your curiosity the field name was "VarsityVenue" to which I renamed it  
as "VVenue".

Thanks
--
Eric Browning

On Nov 5, 2009, at 1:30 PM, Jolle Carlestam wrote:

> 6 nov 2009 kl. 06.00 skrev Eric Browning:
>
>> Lasso 8.5.6 on 10.5 server
>>
>> I recently added 8 fields to an existing database and went through  
>> the
>> lasso settings and confirmed that the new fields do indeed show up in
>> Datasources > fields for this database.  I have checked my code and
>> the fields are spelled correctly (including case) in the inline and  
>> in
>> the html code itself.  I have also restarted the webserver running
>> lasso to no avail and I can update those new fields using the  
>> database
>> browser so it's not a mysql thing.  Any ideas?
>
> It is a Mysql thing. The error message is sent from Mysql. You  
> probably have a syntax error that causes the error. Try to insert  
> action_statement inside the inline container. That will show you the  
> exact query sent to Mysql. Copy it and use it with Mysql directly.  
> Either in the Lasso DatabaseBrowsers SQL window, on the command line  
> or using your favorite Mysql interface.
> You'll get the same error and probably by examining the query can  
> figure out why it isn't working.
>
> HDB
> Jolle
>
>
> --
> This list is a free service of LassoSoft: http://www.LassoSoft.com/
> Search the list archives: http://www.ListSearch.com/Lasso/Browse/
> Manage your subscription: http://www.ListSearch.com/Lasso/
>
>

--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/Lasso/Browse/
Manage your subscription: http://www.ListSearch.com/Lasso/