Search results for query: *

Am trying to write a stored procedure.. Sort of.... SELECT CASE @prmFlag WHEN 'O' THEN (select @prmTDate = @prmTDateOpen ) WHEN 'C' THEN (select @prmTDate = @prmTDateClose ) END Does not like the select ( or set) All advice much appreciated. Kind regards Stephen

I have upgraded a db to 2003, some users are using access runtime, they do no longer seem to hit the security workgroup. The shortcut they are using is.... \\Server\MARKET.mdb /wrkgrp \\Server2\Security.mdw Is there another tweak i need to complete? Thanks Stephen

I have upgrade a an Access 97 db top 2003, one of the functions returns a 3420 error execute, falling over when closing the record set. Code is quite basic Dim db as database Dim rst as DA0.recordset set db=dbEngine(0)(0) set rst = db.OpenRecordSet("select.....") rst.movefirst 'Do some...

I have a cross tab query for which i cannot be sure what the column header will be. Can i add form field dynamically? Thanks Stephen

I have a form whose record source is based on the following query..... SELECT * FROM Archive WHERE CONTAINS (*, '"Winston"') The text, in this case 'Winston' come from a text field in the search form. How do i deal with increased complexity in the search criteria? Has anyone an example vb...

I have a java scitpt to open a window on the click of a image button, but when clicked the new window opens but the original screen refreshes. How can i stop this. Code as below. Thanks Stepehn Protected Sub ImageButton1_Click(ByVal sender As Object, ByVal e As...

I have a text file on which i would like to get rid off anything after a certain phrase. Basically it a import for a database and the last import is no longer required. My text file is of the format.... *tab_imp1 001 002 003 *tab_imp2 003 004 006 I do not want to do the second imports so i...

Sorry to maybe ask an obvious questions but i only touch on UNIX once in the blue moon. I have a created a symbollic link between two directories, however the permissions on the target directory does not give read permissions to the owner of the destination directory. What ways are there around...

I have a direcoty of images. How can i can i create a list of these images as a datasource for a thumbnail page? I have tried creating a object datasource and corresponding buisness object but to be fair i'm not sure if this is the correct method...... Namespace PubsClasses Public Class...

I have a stored procedure which i use to populate a gridview. Some of the gridview columns have visible set false but on export i make them visible by looping through all the columns. My export button is on the master page, code, .... Dim gd As New GridView gd =...

I have tried to create my first custom validation on a text box using funciton on the net. The text box is to be passed to a stored procedure. Validation always returns false, i'm not sure if the funciton is being called at all. Validation occurs when you press 'enter', and it always seem to...

I'm running a stored procedure on my SQL Server, it takes a minute or two depending on the passed parameters. When i attach my .Net page the page always times out after 30seconds, but in may sting i (think) i have set the timeout to 200s. web.config as below.... Where should i be setting the...

How can i return all fields from active directory? Currently i have..... SELECT * FROM OPENQUERY( ADSI, 'SELECT department, homephone, mobile, physicalDeliveryOfficeName, mail, telephonenumber, lastLogon, distinguishedName, givenname, sn...

I have a gridview for which i cannot nail down the column widths, it always seems to be dependent on the data returned. Usually its variable length text field which throw the spanner. How can I nail these values down. Alternatively I have seen a property you can set in the css table format-...

Very new to javasript, so please understand if i ask stupid questions? How do i dynamically rename a Gridview column header? I am calling a function on mouse over event, the funciton pulls a value from hidden column which i would like to use as the header text. All help and suggestions much...

I have a gridview showing the stock level of a number of different items, the values sit into a grid of 12 columns relating to 12 possible sizes, the size range of each item can be different ( examples 1,2..12 or S,M,L), i have returned these in a further 12 hiddne columns in the gird. How i...

All my pages which reference my data.master display their data in Gridview1. I would like to add an export button which exports this gridview on the footer of the master page. With current efforts Data.master doesn't seem like referencing Gridview1 as, i guess, i doesn't really know about it...

I have a very simple sitemap but cannot seem to map the image icon..... <siteMapNode url="Default.aspx" title="HOME" description="HOME" ImageUrl="Icon.jpg" > </siteMapNode> When i try to 'manually' map the ImageUrl under the Menu>Databindings>SiteMapNode>ImageUrl i am give a choice of the...

I have a a gridview in which i total a column, with pagination turned on it only totals 'what is visible'. How can i total all? I had origionally though of 'copying' the gridview, turning off pagination and hiding all but the footer, but can't hide data rows. What other suggestions have people...

Is there a way of querying on hidden characters. Users have pasted into a memo field and all sort of hidden 'line feeds' and 'return carridge' characters have come accross confusing the uses in display. How can i pick these out? Thanks Stephen