Course Queries Syllabus Queries 3 years ago
User submissions are the sole responsibility of contributors, with TuteeHUB disclaiming liability for accuracy, copyrights, or consequences of use; content is for informational purposes only and not professional advice.
Your issue is probably the +. This only does string concatenation in SQL Server and related databases.
This may do what you want:
UPDATE cursos c
SET c.SYLLABUS = CONCAT('https://www.upv.es/pls/oalu/sic_asi.Busca_Asi?P_VISTA=&P_IDIOMA=i?p_codi=',
c.CODE, '&p_caca=act')
WHERE c.SYLLABUS = '' AND c.CENTER NOT LIKE 'Study Abroad';No matter what stage you're at in your education or career, TuteeHUB will help you reach the next level that you're aiming for. Simply,Choose a subject/topic and get started in self-paced practice sessions to improve your knowledge and scores.
manpreet![Tuteehub forum best answer]()
Best Answer
3 years ago
I'm com/tag/try">trying to update a field called "Syllabus" using this SQL query:
But I'm getting this weird error saying I'm com/tag/try">trying to input a DOUBLE com/tag/value">value on line 2 whenever I com/tag/try">try to execute it. Any suggestions on how I could fix this problem?