Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. G12Consult

    Help with Json

    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" }...
  2. G12Consult

    Help with some code

    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...
  3. G12Consult

    Javascript from Content Pages

    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...
  4. G12Consult

    Retrieve data from JSON

    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"...
  5. G12Consult

    Table architecture advice

    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...
  6. G12Consult

    Geography data type error

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

    Geography data type error

    Yeah tried that. still doesn't work.
  8. G12Consult

    Geography data type error

    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...
  9. G12Consult

    Implicit conversion from data type error

    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...
  10. G12Consult

    Implicit conversion from data type error

    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...
  11. G12Consult

    Implicit conversion from data type error

    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
  12. G12Consult

    Implicit conversion from data type error

    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...
  13. G12Consult

    Implicit conversion from data type error

    Nvarchar Should it be something else?
  14. G12Consult

    Implicit conversion from data type error

    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...
  15. G12Consult

    Loop through a column to find a specific value and return the value of another column

    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...
  16. G12Consult

    Loop through a column to find a specific value and return the value of another column

    Hi, I am trying to find some vba code that will allow me to loop through a specific column of a specific sheet and return a value from another column and write that to a cell in another sheet. So my data to loop may look like A B P100000 10 P134454 111 P100000...
  17. G12Consult

    League Fixture Generation code

    I have the following code which generates fixtures, however I would like to modify the code so I can use the following variables: - Start Date / End Date of Season. So generate fixtures for each saturday or sunday between those two dates - Only schedule matches for specific times - Assign how...
  18. G12Consult

    Different landing pages for different roles

    Hi, I am developing an asp.net core website and want to know what is the best way to create different layouts for different role types after they login. I can redirect users to pages no problem after authentication but looking for advice on setup after that. Should I have a .aspx page for...
  19. G12Consult

    Consume web service data daily

    Thanks for your reply. I was looking for suggestions on best ways of getting the data into SQL Server. Should I consume the web service using asp.net (app language) or is there a way to do this from a stored procedure and an scheduled job
  20. G12Consult

    Consume web service data daily

    Can someone point me in the right direction for the best practice approach (security, efficient etc) of consuming data (automatically through scheduled jobs) from a web service daily and storing information into SQL server. a vendor offers a web service where I can pull through my client...

Part and Inventory Search

Back
Top