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

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

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

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

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

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

Hi im fairly new to XSL and im i have no idea how todo the following. I'm in a for each loop of a range which happen to be data values - OrderItems. I have another range called OrderItemsHeader which basically is the field name. I want to loop throught the item and then create a tag and...

Quick Q, Im currently refering to a control using the following syntax: pg.Controls(&quot;cboStandardFloorsServed&quot;).List Is it possible to use the following pg.Controls(varA).List -- where varA is a string with the data &quot;cboStandardFloorsServed&quot; Thanks in advance

Hi, Ive just started using the VBA IDE and ive managed to mess up my windows .. my property window wont sit properly as the bottom left of the screen below the project explorer its all about docking etc.. but I cant get the windows to sit like they used to. How do i re-set the IDE so the...

Hi there, Im having problems passing form controls to a class which i have written. Im using the following approach, which isnt working:-- outside class ------------ classname.addControlData(Multipage.PageName) inside class ----------- 'class methods Public Sub addControlData(PageName)...

Hi there, Ive recently started on VBA moving from Java coding JCreator 3 and I really miss &quot;code folding&quot; the ability to minimise functions etc.. to enable easy navigation of code. Any ideas Thanks in advance

Hi Im new to both VB and VBA im having problems with the following. str = Range(&quot;SheetName!RangeName&quot;).Cells(2, i).Value It seems as if the types are no the same. How can i make the value from range a string ? Thanks in advance W

Is it possible to use inheritance in classes in VBA 6.3 ??

I wish to create some classes for datatypes in my Excel XP VBA project. Is it possible? If so can someone direct me to a relevant article. I know what i want to to is possible in ASP (VBScript) Thanks in advance W

Im using the Microsoft Office web component - MSODSC a grid view. In some of the sample code ive come across the object value attribute contains a reference to some XML data see example below. <OBJECT id=MSODSC classid=CLSID:0002E530-0000-0000-C000-000000000046> <PARAM NAME=&quot;XMLData&quot...