Search results for query: *

-Intro- Hi there Ive recently started work at a small to medium sized web dev company. At College I had the fortune to get to play with XML, XSL, XSLT etc.. My new company however is somewhat a little set in their ways. -/Intro- -Background tech- The company uses a mixture of Java Struts...

Hi i need to remove a navigation table (nav table) in a large number of files. How do I construct a reg exp so that the table will be remove this. The contents of the table vary from file to file. <table id="NavTable> Varying text here <some tags> </table> Thanks in advance

Thanks guys..

I have a table- tblPlantedOn SeedID | field2 | FarmID 12,1,4 12,2,4 1,2,4 1,4,5 I want to figure out which farms have only one type of seed planted on them. The one thing that is causing me problems is that the two entries on farm 4 only count as one seed. This anyway is discounted here as...

Im trying the SQL following code.. UPDATE [Order] SET InvoiceTo = RTRIM(InvoiceTo) WHERE (RIGHT(InvoiceTo, 1) = ' ') However im getting a multirow modification error when i try and run it against my order table. Order is a really big table.. I hate working on Holidays :(

I have a list box which is quite large .. say 16000 records I need to figure out a good way of searching it.. I had a while loop to search the whole list but that is now taking too much time. I ran into this API method: lngindex = SendMessageString(List1.hwnd, LB_FINDSTRINGEXACT, -1, strFind)...

I am using a two SQL Querys - one is nested inside the other. I want to have the subquery (Query 2) generate an additional row if only one row is returned. Any ideas Query 1: Select TOP 1 * WHERE asdf = "XX" ORDER BY asdf ASC { Query 2: Select TOP 2 * WHERE bla = "YY" ORDER BY...

Got it cmbCurrentState.value = cmbCurrentState.ItemData(0)

I have a combo box which i set its row source at run time. I cant seem to set it so that a particular value eg the first value is selected once populated. This has to be any easy one but i cant seem to get it. Help Cheers W

Hi Folkes, I have no prior knowledge with exchange so this is a long shot any help would be appreciated. Currently my group is using the Office Web Access - however we each have 2 email accounts. 1 for internal exchange and another for external ISP emails.. is there any way of telling Exchange...

That code seems to work ok but as such as I change the value for the OrderId to a variable it gives me the following... set @str = 'UPDATE dbo.OrderItems SET'+ @tmpFieldName + '="'+ @tmpFieldValue +'"WHERE OrderID ="'+@OrderID +'"' Server was unable to process request. --->...

I need to escape an apostrophe e.g. SET ' + @tmpFieldName +' = "'+ @tmpFieldValue + '" WHERE OrderID = "' + @OrderID + '=9563'

How do I escape the ' in T-SQL ?

Thanks alot guys for your help :)

Hi there folkes :) Ive run into a problem with my update statement. In it I wish to have a variable represting a FieldName and another representing the new value. Here is my code however the update statement wont work as the variable field name takes the value of the value. How do I fix this...

No its tmpFieldName = tmpFieldValue But thanks for reading

Hi Mark or anyone else can you help me debug the following function. The Initial insert works but the UPDATE doesnt seem to work any help appreciated. CREATE PROCEDURE dbo.sp_Orders_InsertProposedOrderItems( @OrderID [int], @ProductID [int], @Quantity [int], @DateRequired [datetime]...

Hi again SQL Coders thanks for you previous help Quick one .. Im just want to know if its possible or not there is no need to show me how any way... Is this possible forgive my t-SQL like pseducode create procedure sp_addproduct var @producttype var @productdata //productdata will be in the...

Thanks Denny :) Now to write those following statements

Hi Helpful SQL coders, Im behind on a deadline and would really appreciate some help. Im soberly new to T-SQL :( I've a webserice calling a stored procedure to insert data. Can someone show me an example on how to use variables in stored procedures. This is as the fields affected by the call...