sivech3333
New Contributor
Joined 2 years ago
User Profile
User Widgets
Contributions
Re: All the showing as u0000 for a Jsonfile
This is how i connect to database and extract a value. Script and quesry works fine with all the values,But when it came to Json, It returns everything in \\u0000 format function GetDataSetFromDatabase(sql,fieldName) { var AConnection, RecSet; AConnection = ADO.CreateADOConnection(); AConnection.ConnectionString ="Provider=MSDASQL.1;Persist Security Info=False;Data Source=BSDSN"; AConnection.LoginPrompt = false; AConnection.Open(); RecSet = AConnection.Execute_(sql); let value=RecSet.Fields.Item(fieldName).Value AConnection.Close return value } BSDSN is the database name we gave in th ODBC. My query looks like use B2B select top 10 * from database where table1 = 1235 and Type = 'Request' The data in Database looks like {"id":{"abc":"11111"},"productGroup":"FLEXLINE","flexline":{"purposeType":"NEW","purposeInfoType":"PURCHASE","propertyType":"PRIMARY_RESIDENCE","planLimit":552500.00,"revolvingCreditLimit":552500.00,"pricingProvince":"ONTARIO","closingDate":"2023-05-09","interestRate":{"rate":4.10000,"rateType":"VARIABLE","variance":0.000},"flexTerm":{"amortization":30,"amountRequested":552500.0,"rateEffectiveDate":"2023-05-09","flexTermProduct":"FLTV060C","interestRate":{"rate":5.140,"rateType":"VARIABLE","variance":-1.040},"paymentDetail":{"paymentFrequency":"MONTHLY","firstPaymentDate":"2023-06-09","paymentAccountNumber":{"bank":"002","branchNumber":"31682","number":"81922"}},"rateExceptionInd":"NO"},"preApproval":false}}All the showing as u0000 for a Jsonfile
Hi team, I am trying to get a Json file from Database using a query. But the retruned variable is as below. "\"\\u0000\\u0000\\u0000\\u0000\\u0010\\u0000\\u0000\\u0000ߧ\\u0005\\u0011\\t\\f\\u001e꾀〉\\u0000\\u0000\\u0000\\u0000\\u0005\\u0000\\u0000\\u0000㍖ㄮ3\\u0000\\u0000\\u0000\\u0000\\u0000\\u0000\\u0000\\u0000\\u0000\\u0000\\u0000\\u0000\\u0000\\u0000\\u0000\\u0000\\u0000\\u0000\\u0000\\u0000\\u0000\\u0000\\u0000\\u0000\\u0000\\u0000\\u0000\\u0000\\u0000\\u0000\\u0000\\u0000\\u0000\\u0000\\u0000\\u0000\\u0000¦\\u0000\\u0000\\u0000\\u0000\\u0000\\u0000\" I use JS and the returned varialbe is in nvarchar(max) format in database. How to resolve this
