Search results for query: *

Hi, I have 2 tables, wce_contact and PC_WiredOrder. I want to copy data from PC_WiredOrder into wce_contact, that is not difficult. The issue comes when the PC_WiredOrder table has duplicates in it, it then conflicts with the unique primary key in the wce_contact table. That is because i'm...

Hi, I use the following script to merge data from one table into another. This works fine 99% of the time. The issue I am having is that on occasion the data in in the source table pc_wiredorder holds multiple records with the same customerid, which is merged into the destination table...

Hi, I am new to PHP and am trying to connect to a JSON API where I will retrieve some data from a property booking system. The API provider provides sample code see below, you just add your API Key and Property ID, when the code is loaded you should see the property details in JSON format. I...

Hi I am trying to connect to a JSON API using Ajax located here https://api.beds24.com/json/ I want to be able to retrieve property data, add new and update existing properties which can all be done with this API. Problem is I have never used an API before and am going round in circles after...

wHi There, I hit an issue today that I am scratching my head with, any guidance would be much appreciated. I am trying to come up with a query that SUMS all the rows 'Total_After_Discount' field values above and including when the row where the value in the quote_print = 'DT is found and for...

Hi, excuse me if this is a little hard to follow. I have a table that stores bookings for properties called wce_activity_temp, this holds the property name and the start and end dates etc. I have another table that stores the properties names and some other bits realted to the properties...

Hi, think this is the right forum?! I have a classic ASP script that works a treat to calculate directory sizes and write them back to a database, code below. The problem I have is I need to run the script in task scheduler on Windows server which you can't do with a .asp file. Apparently a .vbs...

Hi All, I am very new to PowerShell but love what I am seeing. I have found a great script exports the folder names, create dates, file path and file type information to a .csv file. What I really need now is to add a column that show the overall folder size including any sub directories. I...

Hi there, I am very new to JQuery and found a great function that adds days to a date. Here is the link to the working Jfiddle example http://jsfiddle.net/MCzJ6/1/ I took this code so that I could test it locally but it will not function. The error I am getting is SCRIPT5009: '$' is...

Hi There, probably a silly question but. I have a virtual server with a fix IP 1.2.3.4 for example. I point multiple domains and sub domains to this server ip 1.2.3.4. When there is no domain (http://1.2.3.4:80) configured in IIS you get auto redirected to the Microsoft default blue splash...

Hi There, probably a silly question but. I have a virtual server with a fix IP 1.2.3.4 for example. I point multiple domains and sub domains to this server ip 1.2.3.4. When there is no domain (http://1.2.3.4:80) configured in IIS you get auto redirected to the Microsoft default blue splash...

Hi There, I have been running the following query and it has been working fine. Today I ran it and I get an error: Invalid Column name 'Duplicate_Record'. That column does exist and if I do select duplicate_record from wce_contact I get no error. I have clear the cache but that did nothing, any...

Hi, Looking for help with a bit of a complex query that is going over my head. In my sample data there are two salesorderid’s, 1 and 2, which both have products associated to them, order 1 has 2 products and order 2 has 3 products. Each sales order also has a product row ‘card fee’ with a null...

Hi, I have a strange data formatting issue that I can't get my head round. In SQL 2008 R2 I have built a really simple stored procedure that accepts two date parameters. See below. Here is the create/alter code for the procedure. USE [database] GO /****** Object: StoredProcedure...

Hi There, I want to develop some graphical reports using SSRS. I understand how to connect to the database and add data sets etc. What I don’t know is the best way to structure the datasets. There are two databases a system database for users details, user names and permissions etc. and a...

Hi, I have a string that will vary in length but there will always be a consistent pattern. Var String = “value a; value b; value c;” This string could go on with additional value value e; value f; etc etc. What I need to do is to take that variable “string” and create a new variable...

Hi there, I am having trouble getting a math function to add to currency values together. The issue is the rounding, here is a basic example. var c is returning 3761 and it should be 3762.38 I have played with a lot of examples but can't get it working. Is there a simple method out there to...

Hi There, I have written an ASP page that links with an SQL database. A user can enter a value in a single field and search the database, when results are found they are returned in the asp code. The code all works fine and does what i need but i am concerned that having the SQL in the same...

Hi, I have some code that forces a value from a popup window back to a field in parent page that the popup was launched form and it works fine. See below opener.document.contact._address1.value = “Address 1” I have set this same code up in a slightly different environment and I am getting...

Hi all, I have this code which uses an SQL query to extract fields from a table into a .csv file and it works. The issue is there are two date fields in the query and they are be converted to US date format when they should be UK. The date format on the 2008 server is set to united kingdom and...