Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Showing results 1 to 25 of 132
Search took 0.01 seconds.
Search: Posts Made By: chrislepingwell
Forum: Visual Studio 2005 August 24th, 2007, 06:36 AM
Replies: 2
Views: 653
Posted By chrislepingwell
Thanks Peter. There are two secrets to...

Thanks Peter.

There are two secrets to success in this world:
1. Never tell everything you know
Forum: Visual Studio 2005 August 23rd, 2007, 04:30 AM
Replies: 2
Views: 653
Posted By chrislepingwell
Build Specific Settings?

Hi everybody!

can someone please tell me how I can set different connection strings for different build stages using VS2005?

I want to connect to our 'Dev' database while I'm running in debug,...
Forum: ADO.NET August 31st, 2006, 06:27 AM
Replies: 0
Views: 1,404
Posted By chrislepingwell
Dataset Designer Question

Hi People,

this is probably a really simple question, but how do I get the TableAdapters to recognise changes to the parameter lists of underlying Stored Procedures? I expected some kind of...
Forum: SQL Server 2000 May 24th, 2006, 06:29 AM
Replies: 2
Views: 1,097
Posted By chrislepingwell
ISO Date Problem

Hi All,

I'm hoping someone can help me with an odd problem that has just appeared on my dev client system - Query Analyser, EM and ADO have all stopped recognising 'yyyy-mm-dd' as a valid date...
Forum: SQL Language November 24th, 2005, 06:49 AM
Replies: 1
Views: 1,135
Posted By chrislepingwell
Whether or not to merge two tables

OK, a quick question of of style over substance here.

I have a database that someone else designed (very, very badly) and I'm trying to redesign it into something approaching a real db structure. ...
Forum: ADO.NET August 3rd, 2005, 09:57 PM
Replies: 4
Views: 2,159
Posted By chrislepingwell
OK, I've come up with a work-round (which is...

OK, I've come up with a work-round (which is probably better coding anyway). Instead of using a temp table, declare a table variable to hold the data. e.g.
DECLARE @PDropTemp TABLE([TagIndex] as...
Forum: ADO.NET August 3rd, 2005, 08:32 PM
Replies: 4
Views: 2,159
Posted By chrislepingwell
eadred, I don't have the solution to your...

eadred,

I don't have the solution to your problem, but I can tell you what's causing it (I've been trying to solve this myself for a few hours!). It is the use of the temp table. ADO.Net is...
Forum: ADO.NET July 21st, 2005, 09:27 PM
Replies: 6
Views: 3,008
Posted By chrislepingwell
Cheers Peter, It was a simple as I'd hoped...

Cheers Peter,

It was a simple as I'd hoped :)

Chris

There are two secrets to success in this world:
1. Never tell everything you know
Forum: ADO.NET July 17th, 2005, 09:58 PM
Replies: 6
Views: 3,008
Posted By chrislepingwell
How to create a Global Database connection?

OK, I'm sure this is simple, but I'm only just beginning to play with ADO.NET.

How do I create (and use) a single database connection to use with all Adapters in my project? It's going to...
Forum: Excel VBA March 15th, 2005, 08:25 PM
Replies: 3
Views: 2,222
Posted By chrislepingwell
CopyFromRecordset and ADO.NextRecord

OK Team,

I need to retrieve five queries from (Stored Procedures) SQLserver and paste them onto five different worksheets. I thought I'd try to be clever and get all the data in one hit using the...
Forum: SQL Server 2000 September 1st, 2004, 10:28 AM
Replies: 3
Views: 888
Posted By chrislepingwell
Presentation issues should really be addressed at...

Presentation issues should really be addressed at the front-end. SQLServer is a database engine, not a printing/formatting system and as such has very limited formatting capabilities. Also, from a...
Forum: Excel VBA August 17th, 2004, 10:18 AM
Replies: 5
Views: 2,125
Posted By chrislepingwell
Loane, I gotta ask - what on earth are you...

Loane,

I gotta ask - what on earth are you trying to do here anyway? I'm thinking that if this is your problem, you're possibly trying to solve the wrong thing. What are you intending to do with...
Forum: Excel VBA July 27th, 2004, 11:46 AM
Replies: 3
Views: 723
Posted By chrislepingwell
The only solution we've come up with is 'user...

The only solution we've come up with is 'user education' (a hard task at the best of times:()! Basically, don't open both models in the same Excel instance.
If that's not feasible, then the best...
Forum: Excel VBA July 27th, 2004, 03:51 AM
Replies: 3
Views: 723
Posted By chrislepingwell
I'm guessing that Model B has a lot of formula...

I'm guessing that Model B has a lot of formula calculations in it, and that when you run Model A, 'A-code' at some point calls for a recalc, this will also cause model B to recalc. We suffer the...
Forum: Excel VBA July 26th, 2004, 04:12 AM
Replies: 4
Views: 1,279
Posted By chrislepingwell
Well, you could always remove the Macro option...

Well, you could always remove the Macro option from the Menu on loading the document. But remember to leave yourself a way back in :).

chris

There are two secrets to success in this world:
1....
Forum: Access July 21st, 2004, 07:05 AM
Replies: 0
Views: 1,044
Posted By chrislepingwell
Linked Tables to non *.TXT files

I hope someone here can help me. I have a database that operated quite happily under Access 97, linking to a bunch of text files with extensions like .prn, .qry, null extension etc. Now, in XP,...
Forum: BOOK: Beginning ASP.NET Databases July 19th, 2004, 08:48 AM
Replies: 2
Views: 870
Posted By chrislepingwell
Might I suggest that you post this in the...

Might I suggest that you post this in the 'Beginning ASP Databases' forum under 'Books', not the site feedback forum :)

Chris

There are two secrets to success in this world:
1. Never tell...
Forum: Excel VBA July 16th, 2004, 05:36 AM
Replies: 6
Views: 1,614
Posted By chrislepingwell
If you don't want to save anything in the...

If you don't want to save anything in the workbook add the line thisworkbook.saved True
to the Workbook_BeforeClose event. This tricks Excel into believing that there have been no changes since the...
Forum: Excel VBA June 25th, 2004, 08:24 AM
Replies: 2
Views: 1,244
Posted By chrislepingwell
OK, Sheet3 is the default object name of...

OK, Sheet3 is the default object name of worksheets("Sheet 3"), it can be changed to whatever you want from the Properties pane in the VBE. And although .Cells is not necessary, it is a good idea...
Forum: SQL Server 2000 June 8th, 2004, 11:35 AM
Replies: 8
Views: 969
Posted By chrislepingwell
Nope, it's definately the duplicates. you're...

Nope, it's definately the duplicates. you're getting the 'cartesian product' returned. Essentially, for each match in the right-hand table, you get all the matches from the left. Hence nine...
Forum: Excel VBA June 1st, 2004, 12:29 PM
Replies: 5
Views: 2,059
Posted By chrislepingwell
Your problem is that you are returning the entire...

Your problem is that you are returning the entire recordset as if it were a StringANITEDataExtract = Str(rsPubs)

try ANITEDataExtract = rsPubs.Fields(1).Value
or keep it as a Sub and use...
Forum: Excel VBA June 1st, 2004, 05:49 AM
Replies: 4
Views: 1,070
Posted By chrislepingwell
The answer to your problem is to associate the...

The answer to your problem is to associate the code with the SheetActivate / SheetDeactivate events.
Go to the codepage associated with ThisWorkbook for whichever project you are working in.
At...
Forum: SQL Server 2000 May 24th, 2004, 12:06 PM
Replies: 10
Views: 2,097
Posted By chrislepingwell
OK, I'm still thinking that adding your own...

OK, I'm still thinking that adding your own sequence indicator is the way to go, all we need to do is work out the best strategy for putting it there.
Do you get this table as a discrete object, or...
Forum: SQL Server 2000 May 24th, 2004, 11:47 AM
Replies: 10
Views: 2,097
Posted By chrislepingwell
Chris, I'm not sure you can actually do what...

Chris, I'm not sure you can actually do what you're after using SQL (without some very dirty cheating). It might be that using Excel VBA (or another programming language) is the better method - the...
Forum: SQL Server 2000 May 17th, 2004, 05:42 AM
Replies: 9
Views: 15,083
Posted By chrislepingwell
Just an idea here, but how about pulling the...

Just an idea here, but how about pulling the image into an ADO object (VB or C or something), then writing it back into the text field? you'd probably have to 'manage' the conversion yourself - pass...
Showing results 1 to 25 of 132

 


All times are GMT -4. The time now is 06:48 PM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.