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 139
Search took 0.01 seconds.
Search: Posts Made By: darkhalf
Forum: Classic ASP Basics June 18th, 2009, 11:44 AM
Replies: 4
Views: 696
Posted By darkhalf
Thanks for the info...

Thanks for the info...
Forum: Classic ASP Basics June 12th, 2009, 03:24 PM
Replies: 4
Views: 696
Posted By darkhalf
Yeah, I agree that the aforementionned method...

Yeah, I agree that the aforementionned method woudl work, but I happen to have quite a few <option> tags... for multiple <select>.... I'm not pulling the option from the table, though that woudl make...
Forum: Classic ASP Basics June 7th, 2009, 03:40 PM
Replies: 4
Views: 696
Posted By darkhalf
fun with <select> via DB...

Hey,

I'm populating form elements with data from a DB, but how do I select the <select tag with the the entry?

For example - I have this:
<select name="fruit">
<option...
Forum: Classic ASP Databases April 16th, 2009, 10:50 AM
Replies: 2
Views: 11,004
Posted By darkhalf
Recordset count

Hi,

How do you get how many records in a recordset...

Set rs = Server.CreateObject("ADODB.recordset")
rs.Open sql,db

I try the following, and it gives me -1, but I *know* that...
Forum: Classic ASP Basics March 12th, 2009, 02:57 PM
Replies: 1
Views: 3,010
Posted By darkhalf
ASP/LDAP - error '80004005'

Have this code, which works from within excel (change a few things due to environment), and I'm trying to make it work using ASP... but when it comes to executing, it fails giving me this:

...
Forum: Classic ASP Databases March 5th, 2009, 10:39 AM
Replies: 2
Views: 1,167
Posted By darkhalf
Thank you, I really like that last option by...

Thank you, I really like that last option by removing the header.. then I just have to move to the "2nd" row and start inputting from there!
Forum: Classic ASP Databases March 3rd, 2009, 04:23 PM
Replies: 2
Views: 1,167
Posted By darkhalf
interpretting Excel data using ASP

Hi,

I'm loading an excel file, and put the data into an Access table - which works fine! The issue is that the data in Excel may not be consistently entered (phone number format for example). ...
Forum: Classic ASP Basics September 17th, 2008, 07:31 AM
Replies: 2
Views: 881
Posted By darkhalf
Ty

Ty
Forum: Classic ASP Basics September 12th, 2008, 08:24 AM
Replies: 2
Views: 881
Posted By darkhalf
asp to excel

Hi, I'm trying to output my query and get it to go to an excel file, but it simply outputs the web table, with no error. I am specifying Response.ContentType = "application/vnd.ms-excel" in the code...
Forum: HTML Code Clinic August 22nd, 2008, 10:11 AM
Replies: 1
Views: 1,836
Posted By darkhalf
Fixed table columns

Hi,

I'm at a lost on how to do this, and pretty much looking for ideas/suggestions...

I want a table, where the first row, and the first column are Fixed, but the rest is scrollable...
...
Forum: Classic ASP Basics July 17th, 2008, 08:50 AM
Replies: 4
Views: 3,432
Posted By darkhalf
Thank you very much Old Pedant, that's exactly...

Thank you very much Old Pedant, that's exactly what I was looking for to do... Also, thank you for correcting my syntax for my connection string...
Forum: Classic ASP Basics July 14th, 2008, 01:45 PM
Replies: 4
Views: 3,432
Posted By darkhalf
Excel Sheetname

Hi,

I'm uploading files to the server to then put the content into access... but to do so, I need to know the name of the excel sheet for the sql query...

rstExcel.Open "SELECT * FROM...
Forum: Classic ASP Basics June 18th, 2008, 01:43 PM
Replies: 6
Views: 1,313
Posted By darkhalf
Thank you! So uploading it is!

Thank you!

So uploading it is!
Forum: Classic ASP Basics June 18th, 2008, 10:28 AM
Replies: 6
Views: 1,313
Posted By darkhalf
FYI This is the error message that I get: ...

FYI

This is the error message that I get:

Microsoft JET Database Engine error '80040e37'

The Microsoft Jet database engine could not find the object 'Sheet1$B4:C12'. Make sure the object...
Forum: Classic ASP Basics June 18th, 2008, 10:17 AM
Replies: 6
Views: 1,313
Posted By darkhalf
Hi, This is good, but in both examples the...

Hi,

This is good, but in both examples the file needs to be on the server itself... I've copied an excel file, and I am able to read it there using this:

Set cnnExcel =...
Forum: Javascript June 3rd, 2008, 10:35 AM
Replies: 4
Views: 1,271
Posted By darkhalf
Hi, I tried your code, but I never get the...

Hi,

I tried your code, but I never get the 2nd grouping at all, I just get 'tab' and tab...
Forum: Javascript June 3rd, 2008, 09:50 AM
Replies: 4
Views: 1,271
Posted By darkhalf
Regular Expression - Exec

Say I have a string that has something like this...

var str = "...toggleAlt('tab','text')..."

Now I know that I should be able to use regular expressions to extract it... but having issues......
Forum: Classic ASP Basics May 16th, 2008, 02:58 PM
Replies: 6
Views: 1,313
Posted By darkhalf
Excel to Access

Hi,

I have a form that will browse to an excel file... but what I can't seem to figure out is how to get the data into access...

I've tried the following with no luck...

Set conn =...
Forum: Access April 11th, 2008, 09:07 AM
Replies: 1
Views: 1,446
Posted By darkhalf
Excel to Access - Date gets reversed

Hi,

I'm storing data from Excel into Access (both 2k3)... but the day & month values are getting reversed if the day is less then 13...

For example... in excel, I have a cell that has...
Forum: Access February 29th, 2008, 12:50 PM
Replies: 4
Views: 1,861
Posted By darkhalf
Also, how am I suppose to reference the Total...

Also, how am I suppose to reference the Total value without doing a select of the value from the first table?
Forum: Access VBA February 29th, 2008, 12:24 PM
Replies: 2
Views: 1,343
Posted By darkhalf
Query w/ arguments

Hi,

Is there a way to build queres where I could change the arguments via vba?

Say I have this query

SELECT COUNT(ID) FROM MyTable WHERE SubmitDt BETWEEN #01/02/2008# AND #29/02/2008#...
...
Forum: Access February 29th, 2008, 12:13 PM
Replies: 4
Views: 1,861
Posted By darkhalf
Its just odd that Microsoft access does not allow...

Its just odd that Microsoft access does not allow me to run this query in 1 shot... I've tried this in other mediums without any issue...

As to the Format(ActionDt,'yyyy')... what is so wrong with...
Forum: Access February 28th, 2008, 04:19 PM
Replies: 4
Views: 1,861
Posted By darkhalf
Also as a note, I am trying to use this from...

Also as a note, I am trying to use this from within Access itself... I'm not using ASP or anything like that... I've read a few articles that refer to to security settings with the IUSER login... but...
Forum: Access February 28th, 2008, 04:12 PM
Replies: 4
Views: 1,861
Posted By darkhalf
Operation must use an updateable query

Hi,

I'm running the following query, or rather trying... and I keep getting the error 'Operation must use an updateable query', and I can't for the life of me figure out why...

UPDATE...
Forum: Access VBA February 26th, 2008, 12:58 PM
Replies: 3
Views: 901
Posted By darkhalf
Disregard... figured it out by taking a round...

Disregard... figured it out by taking a round about way of doing it...

Dim objExcel As Object
Dim sqlStr As String
Dim objWBs As Object, objXLWB As Object

sqlStr = "SELECT * INTO TempReport...
Showing results 1 to 25 of 139

 


All times are GMT -4. The time now is 07:00 PM.


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