|
|
Posted by Mossy on 01/26/06 13:42
I am currently moving a table from a msSQL DB to a MySQL DB.
I am trying to build the bones of an insert statement by adding strings
to a select statement.
SELECT '(' + job_referenceno + ', ''' + job_title + ''', ''' +
job_category + ''', ''' + job_type + ''', ''' + job_location + ''', '''
+ job_duaration + ''', ' + job_salary + ', ''' + job_contactperson +
''', ' FROM JobDetails WHERE job_active = 1;
This works perfectly until I try and pull an int column from the Table.
When I add a column to the string that is INT the query returns 0 rows,
with no errors.
Can anyone help explain / overcome this?
Regards,
Tomas
Navigation:
[Reply to this message]
|