@Thomas i have successfully created database using H2 console, now I got
the problem errors while retrieving data. I am having a users table when i
have tried to retrieve it
<cfquery name="q" datasource="mydb">
SELECT first_name, last_name, email
FROM users
</cfquery>
<cfdump var="#q#">
getting table not found error, i have even tried with prepending
username.tablename and also dbname.tablename still it gives error schema
'sa' not found same with while using prepending db name. what I have to do
to retrieve the data ? Thanks.
On Tuesday, June 24, 2014 11:39:18 AM UTC+5:30, Thomas Mueller wrote:
>
> Hi,
>
> What did you try exactly?
>
> Regards,
> Thomas
>
> On Monday, June 23, 2014, waseem <[email protected] <javascript:>>
> wrote:
>
>> hi,
>>
>> I am having MySQL database with several tables already now i want to have
>> same tables in the h2 database, i have tried creating the database with
>> same name as of MySQL database but not able to access the data. Can anyone
>> let me know step by step procedure for creating database and running
>> SQLscripts or exporting SQL scripts?
>>
>>
>> Thanks.
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "H2 Database" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to [email protected].
>> To post to this group, send email to [email protected].
>> Visit this group at http://groups.google.com/group/h2-database.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
