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 500
Search took 0.04 seconds.
Search: Posts Made By: pgtips
Forum: VB How-To July 13th, 2006, 08:58 AM
Replies: 2
Views: 7,076
Posted By pgtips
trivial tip really, but you don't need that...

trivial tip really, but you don't need that Q=Chr(34). If you want " inside a string just double it up like this:

newXML = newXML & "<?xml version=""1.0""?>"
Forum: CSS Cascading Style Sheets July 13th, 2006, 08:51 AM
Replies: 2
Views: 715
Posted By pgtips
brilliant, thanks Richard, this has been annoying...

brilliant, thanks Richard, this has been annoying me for weeks now.
Forum: CSS Cascading Style Sheets July 11th, 2006, 09:38 AM
Replies: 2
Views: 715
Posted By pgtips
how to have both right and left aligned text in td

anyone know any nice (or ugly ;)) hacks for this. This is in the context of mandatory field indicators on data entry forms laid out as tables (sometimes form-style and sometimes table style). What I...
Forum: Classic ASP Professional March 9th, 2006, 07:59 AM
Replies: 17
Views: 6,397
Posted By pgtips
why not use @@identity? its supported in Jet 4...

why not use @@identity? its supported in Jet 4 so u can use it for access and sql server
Forum: Classic ASP Professional February 18th, 2006, 10:47 AM
Replies: 1
Views: 7,566
Posted By pgtips
set up a 500;100 error page on your server,...

set up a 500;100 error page on your server, example http://www.aspfaq.com/show.asp?id=2335
Forum: Classic ASP Databases February 18th, 2006, 10:43 AM
Replies: 1
Views: 9,300
Posted By pgtips
http://www.aspfaq.com/show.asp?id=2023

http://www.aspfaq.com/show.asp?id=2023
Forum: Classic ASP Components February 18th, 2006, 10:41 AM
Replies: 2
Views: 3,718
Posted By pgtips
should be "ADODB.Command"

should be "ADODB.Command"
Forum: SQL Server ASP December 19th, 2005, 05:43 AM
Replies: 15
Views: 47,654
Posted By pgtips
Hi ajimi, Sounds like there are problems...

Hi ajimi,

Sounds like there are problems interpreting the data. Try creating a schema.ini to define exactly what is in your text file. Here's a link with an easy way to create one......
Forum: Classic ASP Databases December 6th, 2005, 04:02 PM
Replies: 5
Views: 10,884
Posted By pgtips
use connection.execute to get your recordset, not...

use connection.execute to get your recordset, not rs.open, then it will use the unlimited commandtimeoout you're trying to set
Forum: BOOK: Beginning Regular Expressions December 2nd, 2005, 08:22 AM
Replies: 9
Views: 2,078
Posted By pgtips
well the Not character is usually ^ so Case[^ ]...

well the Not character is usually ^ so
Case[^ ]
should work for you
Forum: BOOK: Beginning JavaScript November 30th, 2005, 08:28 AM
Replies: 2
Views: 5,702
Posted By pgtips
is this any use? ...

is this any use?
http://p2p.wrox.com/topic.asp?TOPIC_ID=3672
Forum: XML November 30th, 2005, 08:17 AM
Replies: 13
Views: 7,062
Posted By pgtips
Hi there, glad you've got it working, but...

Hi there,
glad you've got it working, but frankly I'm amazed that after reading all that stuff you would go with a "hard work" solution like this. There's nothing wrong with using an ActiveX task,...
Forum: Pro VB Databases November 29th, 2005, 11:29 AM
Replies: 2
Views: 1,658
Posted By pgtips
Try adding a Role to the package on the server,...

Try adding a Role to the package on the server, then add the client's user id(s) (or a win group to which the user/s belong) to that Role
Forum: SQL Server 2000 November 29th, 2005, 09:44 AM
Replies: 6
Views: 1,872
Posted By pgtips
looks like maybe a group by will do what you...

looks like maybe a group by will do what you want, something like
SELECT Account Number,Cost Center,Period,SUM(Amount)
FROM ...
GROUP BY Account Number,Cost Center,Period
Forum: SQL Language November 28th, 2005, 04:37 PM
Replies: 4
Views: 704
Posted By pgtips
write 1 again, so if 1 is A+B, then 2 must be...

write 1 again, so if 1 is A+B, then 2 must be A+B+whatever else
Forum: XML November 28th, 2005, 04:37 PM
Replies: 13
Views: 7,062
Posted By pgtips
look in BOL index under "XML, accessing SQL...

look in BOL index under "XML, accessing SQL Server at URL" or "Executing SQL Queries Using Templates" that will tell you all about it. You will see that the queries can be run via a URL like...
Forum: XML November 28th, 2005, 12:20 PM
Replies: 13
Views: 7,062
Posted By pgtips
either you're running the sql through something...

either you're running the sql through something like an ADO command object, in which case that knows the connection details,
or you're accessing the query template over HTTP so the full url points...
Forum: Classic ASP Databases November 27th, 2005, 12:40 PM
Replies: 5
Views: 28,643
Posted By pgtips
What's the point of resurrecting topics that are...

What's the point of resurrecting topics that are months old? Especially to give dodgy advice like that...

For the sake of the archive - IDENT_CURRENT will give the last inserted ID in SQL Server...
Forum: Classic ASP Basics November 26th, 2005, 09:18 AM
Replies: 1
Views: 1,657
Posted By pgtips
this will most likely be permissions problem...

this will most likely be permissions problem trying to create file in c:
try
Set a = fso.CreateTextFile(Server.MapPath("testfile.txt"), True)
that will create file in your web root. If that...
Forum: VB Components November 26th, 2005, 09:16 AM
Replies: 3
Views: 4,026
Posted By pgtips
1. yes 2. no its different because it puts it...

1. yes
2. no its different because it puts it in a COM+ package on the client, but its marked as activated on the server so when you do CreateObject you don't need to add the "serverip" argument
3....
Forum: XSLT November 25th, 2005, 01:26 PM
Replies: 5
Views: 1,258
Posted By pgtips
The salient bits are:- 1. find the first one in...

The salient bits are:-
1. find the first one in each group using this syntax <xsl:apply-templates select="radio[(position() mod $group-size) = 1]" />
2. find all others in the group like this...
Forum: XSLT November 25th, 2005, 11:36 AM
Replies: 5
Views: 1,258
Posted By pgtips
the general method for grouping problems based on...

the general method for grouping problems based on position is here:
http://sources.redhat.com/ml/xsl-list/2000-08/msg00058.html
Forum: VB Components November 23rd, 2005, 07:46 AM
Replies: 3
Views: 4,026
Posted By pgtips
Did you put the dll in a COM+ package on the...

Did you put the dll in a COM+ package on the server? If yes, then you just need to export the package from the server as an application proxy (this creates a .msi file), then run that proxy .msi on...
Forum: XML November 23rd, 2005, 06:12 AM
Replies: 13
Views: 7,062
Posted By pgtips
I haven't used sp_makewebtask before, but I have...

I haven't used sp_makewebtask before, but I have used "for xml" queries a lot.

As I said before, you will need to sort out permissions before you can create/read files from within SQL Server. The...
Forum: XML November 22nd, 2005, 11:26 AM
Replies: 13
Views: 7,062
Posted By pgtips
most likely a permissions problem creating the...

most likely a permissions problem creating the file:
Showing results 1 to 25 of 500

 


All times are GMT -4. The time now is 05:19 AM.


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