Discovering the solution to populating and building a tree structure using jsTree in conjunction with SQL Server, addressing the challenges associated with the

Question

Discovering the solution to populating and building a tree structure using jsTree in conjunction with SQL Server, addressing the challenges associated with the

My current challenge involves using JSTREE to display a list of system modules. The issue arises from the fact that, according to the jsTree documentation, I need to use # in my query to create the tree structure. However, when I execute the following query, it results in an error:

The error message reads: "Conversion failed when converting the varchar value '#' to data type int." My SQL query looks like this:

select mod_id as id,
    (case when (mod_principal is null or mod_principal = 0)then '#' else mod_principal end) as parent, mod_modulo as text,
    mod_vista from crediguate.dbo.modulo m order by m.orden

Using # in the query works perfectly fine with MySQL as demanded by jsTree. Is there any way to list my modules using # in SQL Server?

javascript sql-server jstree

Answer 1

Answer №1

When using a CASE expression, it's important to ensure that all values in the THEN or ELSE clauses have the same data type. In this case, mod_principal is of type INT, so SQL attempts to cast '#' to an INT.</p>
<p>To resolve this issue, consider the following queries:</p>
<pre><code>select mod_id as id,
    (case 
         when (mod_principal is null or mod_principal = 0) then '#'
         else Cast(mod_principal as varchar(1000))
     end) as parent, mod_modulo as text, mod_vista 
from crediguate.dbo.modulo m 
order by m.orden

OR

select mod_id as id,
    (case 
         when (mod_principal is null or mod_principal = 0) then 0
         else mod_principal 
     end) as parent, mod_modulo as text, mod_vista 
from crediguate.dbo.modulo m 
order by m.orden

Answer 2

When using a CASE expression, it's important to ensure that all values in the THEN or ELSE clauses have the same data type. In this case, mod_principal is of type INT, so SQL attempts to cast '#' to an INT.</p>
<p>To resolve this issue, consider the following queries:</p>
<pre><code>select mod_id as id,
    (case 
         when (mod_principal is null or mod_principal = 0) then '#'
         else Cast(mod_principal as varchar(1000))
     end) as parent, mod_modulo as text, mod_vista 
from crediguate.dbo.modulo m 
order by m.orden

OR

select mod_id as id,
    (case 
         when (mod_principal is null or mod_principal = 0) then 0
         else mod_principal 
     end) as parent, mod_modulo as text, mod_vista 
from crediguate.dbo.modulo m 
order by m.orden

Discovering the solution to populating and building a tree structure using jsTree in conjunction with SQL Server, addressing the challenges associated with the

Answer №1

Similar questions

What is the best way to establish a default search query within the vue-multiselect component?

What are the steps to set up auto-building with create-react-app?

Tips on hovering over information retrieved from JSON data

A messaging application powered by socket.io and the Express JS framework

Having trouble retrieving the URL from JSON data - every time I attempt to access it, it just shows as undefined. Any suggestions

Is the JQuery Mobile .page() method triggering an endless loop?

Exploring the world of unit testing with Jest in Strapi version 4

The function(result) is triggered when an http.get request is made

Error: An identifier was unexpectedly encountered while using the Submit Handler

The module 'pouchdb' appears to be missing, functioning correctly on Mac but encountering issues on Windows

Looking to create dynamic pages on NextJS without relying on fixed paths?

When using Mongoose paginate, there is always one missing document

What is the best way to reposition the caret within an <input type="number"> element?

Error encountered with Protractor: 'TypeError: undefined is not a function'

What are the potential drawbacks of relying heavily on socket.io for handling most requests versus using it primarily for pushing data to clients?

Receiving a response from an XMLHttpRequest() within a function

Display a Vue.js div element based on conditions matching a specific variable value

Encountering an issue while attempting to send an image through JavaScript, jQuery, and PHP

Creating a login page with Titanium Appelerator is a breeze

Experiencing a hiccup in your jQuery animation?