Hi
Thank you for your post.
I have fallen foul of writing a trigger for a single row update and having it fail on multiple rows. Its a good one to be cautious of!
Fortunately this trigger is good for multiple record transactions.
Thank you again.
B
Thanks for your post.
When you said 'somewhere else' it prompted me to think triggers! I stupidly created a VARCHAR(1000) variable in the trigger!
Thank you so much.
B
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
Thanks again for your posts:
tlpeter: unfortunately not, the static IP were entered originally and this is what we are looking to change.
amriddle01 & CarGoSki: thanks, we did do this before, but its always good to try again: we have done so but no luck.
Thanks
B
Hi
Thank you for your posts:
"What are you failing to tell us? At some point was your 46xxsettings.txt modified from default?"
Yes it has been modified, this is our test system, unfortunately various team members have modified the file to test configs. Unfortunately I could not tell you...
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...
Sorry for not explaining the whole story... And thanks for your posts:
They are SQL Server DATETIME fields.
Its an ADP
Acutally I made it work by using this code:
stLinkCriteria = "([DateCreated] BETWEEN '" & Format(DateAdd("d", -7, Date), "yyyymmdd") & "' AND '" & Format(Date, "yyyymmdd")...
Hi
Thank you both,
dhookom i have amended as you say however the error still returns.
PHV i get the error 'Date' is not a recognized built-in function name.
This maybe because we are running an SQL Server backend.
Thanks
B
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.