Search results for query: *

Hi We have a VARCHAR(MAX) variable updating data in a VARCHAR(MAX) field but it appears to truncate the data at 1000 chars with no error. The data being loaded is HTML if that makes any difference. I am stumpted, I have checked the coding over and over but cannot see any errors. Any...

Hi We are trying to optimise a web page by reducing the number of sql requests. We have 4 repeaters on the page displaying: Search Results (SQL: SELECT TOP 25 * FROM (SELECT ROW_NUMBER() OVER (ORDER BY Product ASC) as RK FROM View_Products WHERE Code > 200) as a WHERE rk >= 2) Manufacturer...

Hi We have a 4625SW IP phone which we setup on our test IP Office with static configuration on the handset. Now we want to use it in production the handset does not give us the option to change the static values (no * on boot). So we have decided to reset it, no luck there it just does not...

Hi We are trying to open a form showing items from the last 7 days, we have the below VBA criteria: stLinkCriteria = "([DateCreated] BETWEEN #" & Format(DateAdd("d", -7, Date), "d/m/yyyy") & _ "# AND #" & Format(Date, "d/m/yyyy") & "#) OR ([InvoiceDate] BETWEEN #" & _...

Hi We have a form that opens another form. The other form runs a stored procedure against the back-end SQL Server then closes, when it closes it requeries the original form. The SP amends the record open in the main form. Unforunately during the requery appears to write the dirty data in the...

Hi We have a remote webserver running SQL Server 2005 that we need to connect to using TSQL and execute 2 SP's from our office SQL Server 2005. We access the webserver using an IP address & different port number i.e. xxx.xxx.xxx.xx,1192 (the web server is not on our domain) Is there any way...

Hi We have one extension installed today on a remote site (5610SW IP) and are receiving regular alerts from the system that it has been removed then plugged in (every 2 minutes). Here is the spec: Main Site: IP Office SOE Router: Draytek 3300v ..... Lan to Lan VPN ..... Remote Site...

Hi We need to create a primary key / unique column on a view so that we can create a full-text index. I am struggling to do so, any advice would be much appreciated. Thanks B PS: SQL Server Standard 2005

Hi We have a PE2900 running 6 SAS drives attached to a PERC 5/i. We are looking to add some cheap storage to the server and would like to add two 1TB SATA drives as RAID 1 to keep costs down. Am I right in saying that the SAS drives are 2.5" and SATA is 3.5"? If so is there any way of doing...

Hi We have an ADP project linked to SQL Server. A view on the server returns an address field with CHAR(13) line breaks, however these show in the text box on the report as boxes without breaks. I can amend the SQL Server view to suit, ive tried CHAR(10) and CHAR(9)with no luck Thanks B

Hi We currently have a site with a shopping basket which is stored in a datatable for each session. However, customers (and I) don't like that the basket clears after your session ends. So what options do I have? I could give the user a unique ID, if they have cookies enabled I can store...

Hi We have some 4625SW IP phones which were configured with static IPs, which we need to reconfigure. * on boot does not work (as no DHCP prompt) and Hold A D D R # does not work when booted? How can we amend the static IP addresses? Thanks B

Hi I am struggleing to create this update statement with a select/group by clause: UPDATE PP SET PP.Ex = SUM(LPP.Ex) FROM SM_Prod_Pricing PP INNER JOIN SM_NFW_Bundle_Pricing_Link BP ON PP.ID = BP.Pricing_ID INNER JOIN SM_Prod_Pricing LPP...

Hi We have upgraded to Visual Studio 2008 and upgraded our Website to run on .NET 3.5, somewhere things have gone wrong. We have a login page in our site that is in a subfolder, however now when you click the image button to login it appears to be trying to submit to the same page but in in...

Hi We have just upgraded to Visual Studio 2008 and when we publish one of our web projects it brings up the dialogue for publishing windows apps instead of the Web Project publish. Has anyone experienced this? we have clicked the convert to web application option but this does not appear to...

Hi We are trying to acheive a simple solution for our managers. If someone drafts some text but for parts of the document would like to give another reviewer multiple options for different wording, already typed but they can select them from a list. It would need to be simple to type (we...

Hi We are introducing an Out of Hours number which will come into a DDI. We want to direct to: 9-5pm monday - friday: external number 1 Mon, Wed, Fri, Sun: 5pm - 9am (following day) external number 2 Tue, Thurs, Sat: 5pm - 9am (following day) external number 3 What is the best method of...

Hello We have a page similar to a shopping cart... when we post the data we want to load it in the returned page. However it appears that the page load procedure runs before the control command procedure on the page. Therefore the databind occurs before the page modifies it!! Is there a...

Hi We have a shopping cart with a basket on the side of the page. The ASPX page has a 'Loader' user control which detects if there is anything in the shopping basket in the Page_Init, if there is it loads one user control if not it loads another. When you add something into the basket it...

Hi We have to rename the outlook profile name for all our users. We thought that setting up a logon script for the job would be best, the key is: HKEY_CURRENT_USER\Software\Microsoft\Windows NT\CurrentVersion\Windows Messaging Subsystem\Profiles\Default And we need to change it to...