Search results for query: *

How can I detect a value in a multi-line text box then run some code based on the result? EG: Text Box has these values: 123456 123457 123458 123459 1000001 When the user enters the value 1000001, I want it to call some code. Thanks.

Hi, I have an asp.net C# web site and in one of the pages I have a grid view that returns some results and fires a warning sound if the result = 0 (see below): if (gvScnResults.Rows.Count == 0) { SoundPlayer PlaySound = new...

Hi . . . here's an interesting puzzle! I have a multi line text box: <asp:TextBox ID="txtData" runat="server" TextMode="MultiLine" /> Now, suppose a user enters the following: 123456 123457 123458 123459 222111 END As soon as the user types in END, how do I get it to trigger a Submit button...

Hi, I am using Asp.Net 4, C# and MySQL for a task scanning project. Everything works, except I cannot figure out what to do with the else bit! I have a text box that takes input from a barcode scanner. When the data is received, a TextChanged event calls the code below: protected void...

Hi, Here is one I am not sure about . . . or rather, can't figure out how to handle it using FileExists!!! My files look like this: prtx010.prtx010.0199.E7.352.23444151 I want to check a directory for any files that are 36 characters long with E1 to E9 in its name. Any ideas how I can...

Hi, I have a directory with a load of files in it, with each file named E_1, E_2, E_3 etc. There will never be more than 10 files. Now, I want a user to click a button that will do the following to each file. So, do E_1, then delete it, do E_2 then delete it etc . . . . //open the...

Hi, Here's is something which sounds so simple to do . . . . but is proving a mega headache. In a nutshell, I have a text box box and an asp:net form on a web page (C#). A user types in a value and presses the enter or return key. This then sends the user entered value to the database (stored...

Hi, I want to filter records in a grid view using the calendar control . . . . I can get it to work using a text box, but using the calendar is totally eluding me :( Any assistance will be greatly appreciated . . . If it helps, the date (REPOT_DATE) is returned like this example: 23-11-2012...

Hi, I have a directory containing numerous files which I want to rename. The files are always 40 characters in length. Example files: prtx010.prtx010.0199.126291.351.03053254 prtx010.prtx010.0199.336760.335.16530215 This part of the filename is always the same: [highlight...

Hi, I am required to load some text files using LOAD DATA ETC into a db. So far, so easy. However, what I want to know is whether it is possible to import the file using a wildcard? My file name will always take the format below and will always be the same length. However, everything about the...

I have a table with the following example data: Id | field1 1 | abc 2 | 3 | def 4 | 5 | dtg 6 | 7 | abc Is there a way using sql only to fill in the nulls, as in the example below, with the value of the row above it? Id | field1 1 | abc 2 | abc 3 | def 4 | def 5 | dtg 6 | dtg 7 | abc Thanks...

Hi, Hope someone can help me with this as it is driving me nuts! I have an MS Access 2002 front end connecting via ODBC to MySQL 5.1. DB is fully normalised, indexes all fine and dandy etc. Question is this: I have 10 users, each with their own PC and Access front end connecting via an ODBC...

Hi, Does anyone have any ideas how I get tableA to look like tableB? Ignoring the fact that the design of tableA is way short of ideal, it's what I have to work around, so any help will be greatly appreciated: tableA id item stamp 1 111111;111112;111113;111114 10/03/2011 12:00:35 2...

Hi, I am moving from ACCESS to mySQL 5.1 and I am trying to convert some of my queries. Most of it was not too painless, but this one is driving me crackers! I have a table with some numbers in it of the type VARCHAR(8). Now, the numbers going into this table have seven digits: 1234567 1234425...

Hi, I am new SQLServer (2005 version) and have to try and convert the query below. Any pointers? INSERT INTO tblRackList ( loc, cat, t_stamp, status ) SELECT tblRackList_Temp.loc, tblRackList_Temp.cat, tblRackList_Temp.t_stamp, IIf([tblCatNumber.status] Is Null,"N/A",[tblCatNumber.status])...

Hi, Here's a real stumper! In the data below, I want to remove the values that are duplicated, except for the first instance of the duplicate, and replace them with null! Before ID Emp Job StartTime EndTime Qty 46371 431172 476628 20/07/2010 23:35:05 20/07/2010 23:37:56 0 46372 431172...

Hi, I have a directory of files that are always in this format: 123456.txt 845133.txt 123545.txt I can import them quite happily into my database without issues. However, the files get imported based on their modified date. I want to import them in the order they appear in the directoy or by...

Hi, I have a report that prints orders for suppliers. So, for any given date, page one will be all orders for one supplier, page two orders for another and page 3 orders for someone else. And so on. What I want to do is save each of these pages as separate rtf files (one page per supplier...

Hi, In VBA, I want to run an SQL command that will take Table 1 and make it look like Table2. I've seen it done before (but can't remember how!). Anyway, here goes: Table1 Field1 Field2 Field3 12345 123222 112223 122222 122222 18852 123125 121572 152145 115542 551155...

Hi everyone, Can anyone suggest the best way to get ColA values of a plain text to repeat until it changes to another value: Before: ColA ColB 001/0222 901123 001/0255 855524 855524 855524 001/6622 855666 001/1222 123456 123456 123456 After: ColA should never have any null values -...