Search results for query: *

I cannot believe this site is still going, how cool! Can anybody help please. I would like to convert this code to use the sqlserver connection methods. <?php ini_set('display_errors', 1); ini_set('display_startup_errors', 1); error_reporting(E_ALL); $server = "localhost:1433"; $user_name =...

Good day to you all. I have an nvarchar value stored in a table, example such as '(15645),(15646)' and '(15680),(15679),(15678),(15677)' under field name SALES_ORDER_ITEM_ID Example Query; [code=sql]select Pallet.*, Purchase_Order_Item.SALES_ORDER_ITEM_ID from

Hello all I want to configure a report to print a label 3 across and 7 down on an A4 page size. Can anybody advise on where to find instructions on how to do this? Thanks Keyth

I see there are plenty of posts about how to copy database, I have worked with db files quite a lot. without detaching the database and copying files etc, is there not a way it can be done with SQL query? I have an app which I would like to adapt so that at startup it prompts the user to run a...

Hello, I am a newby to ASP.Net but have many years of experience in VB6-VB.Net 2010 and little experience with Java/Servlets. I want to start coding ASP. I have a situation where my host will not allow IP access to MySQL databases. My site is currently built with wordpress and but for my...

Hi Guys n Gals When I query the week number of a datetime column it is returning 3 for WC11/01/2010 whereas on my paper calendar on the wall it is week 2. I understand why the db is returning week 3 but is there an option somewhere I can add/change to count week numbers starting wc04-01-2010...

Hello I am trying to work the PIVOT function but not doing very well at it! How do you suppose I pivot the query below to list the Year/Month as rows and stock_code as column, values to list along the rows will be sum([aii].[QUANTITY]) as Qty SELECT CAST(CONVERT(CHAR(6), [ai].[INVOICE_DATE]...

Hi Can anybody tell me how to change the preferences for Crystal Reports within Visual Studio 2005? I want to change the measurement scale to something more user friendly so I can input MM or INCH etc Thanks Keith

Sorry guys mental block and cant get my head round this one, its only just started happening ?? I think! I have a table which stores datetime values as one of its fields. I query the table as follows; qh.Quote_Date = '20090108' OR and (qh.Quote_Date between '20090108' and '20090109') But...

Can anybody offer any pointers on how to detect network speed? Thanks, Keyth

Hi Guys. I know a lot of you who read this will say "That thread belongs in 'SQL Server Programming'" but if I post this thread in there, they may not know what I am on about because its VB code thats calling the command... I have a problem where I am trying to call the following SQL command...

Hi all. I have just started using ASP.Net 2.0 and am wanting to find HTML/CSS templates. I have looked at the Microsoft ones available but wondered if anybody can suggest any others. Can anybody reccomend any good ASP Master Page (v2.0) template sites? Thanks, Keyth

Hi all. I have just started using ASP.Net 2.0 and am wanting to find templates. I have looked at the Microsoft ones available but wondered if anybody can suggest any others. Can anybody reccomend any good template sites? Thanks, Keyth

Can anybody please tell me why I get the error Invalid column name 'Expr1' in the query text below? SELECT DeliveryNoteID, DelDate, (SELECT COUNT(AutoID) AS Expr1 FROM Transport.dbo.DESPATCH_ITEM AS DI...

Hi everybody I want to be able to get the report title from a crystal report file so that I can add the title as a ListBox Item. The user can then pick the report by title and run it. Does anybody know how to get the title from the rpt document properties/report summary info? I have...

Hiya. How can I set the default value in SQL SVR 2005 bit field to False? And the same goes for nvarchar fields set to empty string? Is there a statement that can be run to convert all null values in nvarchar field to emtpy strings? Is there a statement that can be run to convert all null...

I have created a CSV File using the following function: Private Function outputtocsv(ByVal tbl As DataTable) As String Dim returnString As String = AppPath() & "Exports\EndOfDay.csv" Dim outputtext As String = "" If File.Exists(returnString) Then...

Hi all. I would like to group the following categories so that there is only one line per category and a value in both columns to indicate ordered qtys and not on order qtys Results: Handwork 5 NULL Handwork NULL 30 Merchant NULL 11 POR NULL 583 POR 75 NULL Reelsale NULL 255...

Hi. I have a DataGridView that I add the columns to at runtime. The datasource has a boolean type column and I want to be able to change the button text according to the boolean value. For example: If the boolean value is true then the button text should be "Unallocate" but if the boolean...

Hi All. I am struggling to find a way of detecting when a datagridviewtextboxcolumn has been resized. The columns are constructed at run time and added to the datagridview. I want to be able to detect when a user has resized a column and then when the form reloads set the columns width to the...