Recent content by G12Consult

I have the following JSON output from a URL { "motd": { "msg": "If you or your company use this project or like what we doing, please consider backing us so we can continue maintaining and evolving this project.", "url": "https://exchangerate.host/#/donate" }...

Hi, I have the following code which will give me a list of every fortnight between two dates however I want to be able to make the type part of datadd (so WEEK, MONTH, YEAR) etc dynamic. Is this possible? I have tried creating a user defined variable for it but it didn't work. Basically if the...

I am trying to run a date picker on a field within a content page. On the master page in the head section I have the following code: <script src="../assets/js/forms-bootstrap-datetimepicker.js"></script> <asp:ContentPlaceHolder ID="head" runat="server"> </asp:ContentPlaceHolder>] In...

I am trying to receive data from a json feed. I can successfully perform the http request which gives me some json data like below: jsonObject = {{ "data": [ { "latitude": -20.025382, "longitude": 143.314035, "type": "address", "name": "xxxx", "number"...

Hi, I have been tasked with creating a database used to store statistics for various sports. My issue lies in that each of the different sports have different measures or metrics you would store in a database. For eg. Cricket Metrics - Runs, Wickets, Overs, 4's, 6's, Outs, Wides, No Balls...

This worked though SELECT geolocation.Lat as Lat, geolocation.Long as Lon from INVESTOR.PROPERTIES I read something about case sensitivity regarding spatial data

Yeah tried that. still doesn't work.

I have a field in a table with the geography data type. I can write to the field using a lat & long reference which gives me a value of: 0xE6100000010CF4F8BD5D7F063CC059349D9D0C2A6340 When I try to extract the lat out of that field using SELECT GEOLOCATION.LONG, I receive the error: Could not...

This is still throwing an error. Here is my addnewuser code ALTER PROCEDURE [AUTH].[spADDNEWUSER] @pUSER_ID int ,@pUSERNAME NVARCHAR(50) ,@pPASSWORD VARBINARY(MAX) ,@COUNTRY_CODE NCHAR(2) ,@RESPONSEMESSAGE NVARCHAR(250) OUTPUT AS BEGIN SET NOCOUNT ON DECLARE @SALT...

This is still giving me the same error when I execute the stored procedure. ALTER PROCEDURE [AUTH].[spADDNEWUSER] @pUSER_ID int ,@pUSERNAME NVARCHAR(50) ,@pPASSWORD VARBINARY(MAX) ,@COUNTRY_CODE NCHAR(2) ,@RESPONSEMESSAGE NVARCHAR(250) OUTPUT AS BEGIN SET NOCOUNT ON DECLARE...

I will try to understand your advice and implement. Why would it work locally? Would this be a security setting on the shared server as to why it would not work. The original code works fine and authenticates the user successfully locally. Thanks again

This is my procedure for adding a new user ALTER PROCEDURE [AUTHENTICATION].[spADDNEWUSER] @pTENANT_ID int ,@pUSERNAME NVARCHAR(50) ,@pFIRSTNAME NVARCHAR(50) ,@pSURNAME NVARCHAR(50) ,@pEMAIL_ADDRESS NVARCHAR(50) ,@pCOUNTRY NVARCHAR(50) ,@pPASSWORD NVARCHAR(50) ,@pUSERTYPE int...

Nvarchar Should it be something else?

Hi, I have a SQL database on shared hosting and the following line in a stored procedure is failing and gives the following error 'Implicit conversion from data type nvarchar to binary is not allowed. Use the CONVERT function to run this query.' It works fine locally on my machine How do i...

Sorry probably should have posted my code. It is because I only wanted to find the value P100000. However, now I need to loop through a column with different numbers, so how can I modify the code below. Basically, I have an organisation structure in rows where there is a PositionID and...