Search results for query: *

Hi I have a spreadsheet containing addresses. Some of the addresses are in the format "123 Main Street", while others are "123, Main Street" and some may be "Apt 1, 123 Main Street". I am trying to separate the number part of the address from the rest of the street name so that I am able to...

I have been asked to produce an example of a cursor and then to point out why it isn't required to use on. I am having difficulty creating my example and I was wondering if someone could help me with the syntax to write one. Basically I want to select the FavouriteSport table (below) into a...

I have a query about writing code to use a sql server to loop through a record set in one table and then depending on the record insert a row into a new table. Each night I will receive a merge table file with new values in it. Depending on these values I will want to insert a record across to...

I am trying to write some sql without using a cursor which looks at a row in a table and if the value exists in a row with a previous record no then i don't want to insert the record. In the example below I would like to put another where clause into my insert statement which doesn't allow...

I want to ask everyone about this to see if anyone knows a work-around. My environment is win2003, vs.net 2003, Java 2 runtime environment SE 1.4.2_08 (or jvm1.4 for short). I have a java applet that I want to include in an asp.net page. I can open it in IE6 in a html page and it runs happily...

I've got a real brain teaser which I'm trying to work out. Basically I recieve a merge table in every night which supplies a list of urns which have been merged into other urns. I'm using a .net application to search on urns and return results but when a user input a urn my stored procedures...

Does anyone know if there is a way to hide non-working days (e.g. Saturday, Sunday and overnight) in a Gantt chart? I am trying to compare how long different tasks will take in terms of working hours, not actual time, and the non-working hours make some tasks look as if they are taking much...

Can someone help me. I'm trying to use the following validator control and compare a date to a date defined in the code-behind page. My code is below along with my error message I get when the page is rendering in the browser. Has anyone any idea what I've done wrong? <asp:CompareValidator...

I have an array list alSearchCriteria which contains values which vary each time its created. It will always have 15 items in the arraylist each time its created. Some of the values in the array list will be a string called null. I want to create some way of looping through the arraylist and...

Hey there. I was wondering if someone could advise me whether or not i've writted an effective/efficent stored procedure. Basically the below procedure will be run from a .net application and the values passed the the parameters will be 1 or null. It will allow the user to select as many or...

I have to write a query which i've know idea how to write and was wondering if someone can help me. I've got an asp.net front end and i'm trying to run a query to select all the users in table UserObjects which have a value '1'. This seems simple enough however I have to offer them the...

Hi Everyone I'm going to use my first <asp:CheckBoxList> control to create a list of selections which users can choose from and run a search against. In other words they are going to act as the parameters of query. I want to store the values in the web-config and then bind to the values to...

I have the following stored procedure and was wondering if anyone could help me. I've not written sql in ages and I'm not sure if i'm working efficently. I'm trying to return a dataset to bind to a asp.net datagrid and then I also want to display the total count of records in a label. Does...

I have the following stored procedure below and I was wondering if I will be able to bind the restuls to a datagrid for the first select statement and display the results of the count in a label for the count. I wasn't sure if i should have written two stored procedures to do this or if I'll be...

I've found this code to help me with my session logout problem. Before I had a session and when I logged out everything worked fine and I was brought to the log out page but when i clicked the back button in IE I was brought back into the cached version of the page in IE. I added the below two...

I've been asked to go away and look at Microsoft Message Queue server for sending messages behind the scenes. Has anyone used this before? What do they think of it? Is there any other ways of doing this kind of thing using the event log? If so has anyone got any good links to sites with...

I have the following column and so far im able to bind the column to CompanyName and only return the first 50 characters. The second function i'd like to retun a tooltip for that datagrid cell but i'm not sure if this is possible and if so I don't know how to right a function to return a...

I have a datagrid and i'm trying to fix the width of one of the columns to be exactly 300px. My problem is that one of the records fields(CompanyName) is really long and has no spaces so it streches the whole datagrid accross the screen. Has anyone else ever experienced this problem and is there...

Does anyone know how to do exception handling in vb6. Do you use the Try Catch blocks. If so can someone show me a very quick example of this

I'm trying to keep things simple and display a table from my database in a vb form. I want the form to display like a datagrid. Is this possible and does anyone know how to do this. Is there some datacontrol which I can bind to that acts like a table??