|
I'm trying to do something that is even stumping the web services guys at the company I work. I know it's simple, just can't figure out the syntax! It's also very difficult to explain, so here goes:
I am wanting to SELECT * from a table, and then iterate through each record in the RS, defining each record as a variable with only a few lines of code. For instance, instead of this:
lastName = RS("lastName")
I want to do something like this (I know this syntax is erroneous, only way to explain):
For each Field in RS
[Field.Name.in.RS] = [Field.Value.in.RS]
Next
So, theoretically, when the cursor reaches 'lastName' in the RS, it will create a variable called lastName and assign the value of lastName to it. Make sense? I simply want to select and create variables for ALL results from a query without having to manually state them.
I know someone will want to know why the heck I want to define all these when I can just plug them in HTML as RS("lastName"), but trust me, I need this!
Thanks,
Robby
|
|
|
|
|
Although I haven't tried it, I'd suggest trying this procedure:
1. Select * from the table.
2. Determine the number of records returned, n:
n = RS.RecordCount
3. DIM an array(n) for each variable of interest, First(n),Last(n), etc
4. Iterate through the recordset using this sort of construct:
i= 0
While Not RS.EOF
First(i) = RS.Fields("First")
Last(i) = RS.Fields("Last")
i = i + 1
RS.MoveNext
WEND
This should leave you with a pair of matched arrays, one of each per record returned. Large recordsets could be problematic, but this is what I'd try first.
"Another day done - All targets met; all systems fully operational; all customers satisfied; all staff keen and well motivated; all pigs fed and ready to fly" - Jennie A.
|
|
|
|
|
Thanks, the problem is that I do not want to define anything because I have so many tables with so many different column values. Basically I just want a 2d array that will have the column name and the value for that column. I am only selecting one row on my select statement, so i want array something like:
lastName,doe
firstName,john
column3,True
column4,True
column5,True
column6,True
etc...
Anyone?
Thanks,
Robby
|
|
|
|
|
So basically, something like this?
Function DumpRow(recordset)
Dim arrData, index, count
count = recordset.Fields.Count
ReDim arrData(count - 1, 1)
For index = 0 To count - 1
With recordset.Fields(index)
arrData(index, 0) = .Name
arrData(index, 1) = .Value
End With
Next
DumpRow = arrData
End Function
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
|
|
|
|
|
Our corporate intranet is configured as follows
PDC
OS Windows 2000 Advanced server.
IIS version 5
FrontPage extensions 2003.
Visual Source Safe is configured with IIS for source control.
Nodes
Windows 2000 professional
IIS version 5
FrontPage extensions 2003.
Visual Studio(SP5)
Scenario and problem
We have created a master web application on the PDC. This application is added to source safe also. All development nodes are connected to Master web application through visual Interdev. To debug COM+ components from VID we swith to Local mode in Visual Interdev ‘working mode.’ This results in every request to local application creating a new session.
When working in master mode this problem does not happen.
When we created the web application in a machine which is outside the domain but in the LAN, this problem did not occur.
When we created an application on local IIS of the node, this problem did not occur.
What we have noticed is that it is only when we try this in Domain the problem occurs. Like we simulated the same situation between two nodes of the domain it reoccurred.
Any help will be highly appreciated
Thanks
Anand Thakur
|
|
|
|
|
Hi all
I've got a question about a regex. I would like to check if the user has entered a valid domain name (i.e. "microsoft.com") without subdomain, and abiding by domain name rules (only alpha and numbers and dashes, no dash at beginning or end etc), and I have no experience with regexes... Could someone help me out or point me in the right direction? Googling hasn't given me anything useful (that's prolly my fault though)...
TIA
Paul
Open the fridge door, scream, and everything that doesn't run into the corner is safe for eating. - Jörgen Sigvardsson
modified 18-Jul-18 11:59am.
|
|
|
|
|
This is a deceptively tough question since you have the restriction of not allowing subdomains, so you'd need to build a table of all allowed domain suffixes first in order to build a regex-based algorithm.
An easier (but more resource-intensive) solution might be to do a whois query on the entered domain. There's a set of classes for working with whois lookups here: http://phpwhois.com/[^] With whois, www.microsoft.com would fail, but microsoft.com would pass.
- Mike
|
|
|
|
|
That seems to work well, thanks
Paul
Open the fridge door, scream, and everything that doesn't run into the corner is safe for eating. - Jörgen Sigvardsson
modified 18-Jul-18 11:59am.
|
|
|
|
|
Hi,
I don't know any better subject for this question.
Well, I've a table in my page ... and i should add some long text into the table.
The problem is whenever i add thease long texts, the table change the sizes !!!
I CAN'T use ENTER to break the texts and make new short texts and then use of them in the table.
I'm looking for HTML code or CSS to do it automatically.
In fact i want the table in fix size and static, this code should break the texts to new lines in the table.
Regards,
|
|
|
|
|
<table width="100%">
...
</table>
Is it that what you wanted???
_outp(0x64, 0xAD);
and
__asm mov al, 0xAD __asm out 0x64, al
do the same... but what do they do??
(doesn't work on NT)
|
|
|
|
|
Thanks for reply Dominik
It seems i was too tired when i wrote this question, really sorry.
Now i'm fine
Regards,
|
|
|
|
|
You can set sizes a couple of ways, other than what Dominik suggests. Set the Table width to 100%, then set each column to a % of that, totalling 100% to make the display fill the available space on the user's screen. Or you can set the width of the table to xxx px, and the columns to smaller sizes if fixed pixels (px). A static sizing method like this, though, may look rather strange on various screens, depending on the users' settings. I prefer the % method myself, and moving all such details to a style sheet is even cleaner, as it lets you change settings throughout the site with a few keystrokes.
"Another day done - All targets met; all systems fully operational; all customers satisfied; all staff keen and well motivated; all pigs fed and ready to fly" - Jennie A.
|
|
|
|
|
Ok, this will be an easy question for you peal guys (or gals for that matter)
I have a peal file, for a Form Mail in my website (FormMail.pl)
I have been following instructions to use this file for my wesbite, making changes to the parameters, but what does this mean:
**************
"Once uploaded you will need to change the file so that it can be executed, this can normally be done in any ftp programme"
**************
Do I have to compile this file, or rename it? Either way, if i run the script as it is i get a Error 500.
Hope this make some sence
Hope someone can let me know tonight, if you can spare a mo..cheers in advance
---
Peter M
|
|
|
|
|
Make sure the file execute permissions are set properly. On *nix the file permissions should probably be 755.
Most FTP programs allow this by right-clicking on the file name on the server side, and selecting something regarding 'permissions/chmod .
Also, make sure you uploaded it to a CGI directory.
HTH
"Things are not what they seem. Nor are they any different." BW
CP Member Homepages
|
|
|
|
|
thanks, i found out i needed to make the file executable, and now it runs fine. Thanks for your reply also
Been advice to use ASP now, by a fellow CPian...humm...things to do...things to do...
---
Peter M
|
|
|
|
|
Peter Mayhew wrote:
now it runs fine
Peter Mayhew wrote:
Been advice to use ASP now
I've been avoiding it. I haven't run into any problems working with perl on a linux web server, yet, so I haven't found a pressing need.
"Things are not what they seem. Nor are they any different." BW
CP Member Homepages
|
|
|
|
|
If you want the best of both worlds go with PHP
Embedded like ASP, but C syntax like Perl and open source
The word of the day is legs, let's go back to my house and spread the word
|
|
|
|
|
LOL
---
Peter M
|
|
|
|
|
You're not this Peter Mayhew[^] are you?
--
You're entertaining at least.
|
|
|
|
|
Nope. I get asked that so often though, I had to put the question in a FAQ on my own website!.
Just dont make me angry on a full moon. Some say things get a little hairy.
---
Peter M
|
|
|
|
|
Hi,
I have an entry form and it scrolls vertically. The input fields are at the bottom. Is there a way, when they click edit it would go to the bottom of the page? Thanks,
|
|
|
|
|
I cannot understand what you are asking...
theJazzyBrain
Wise is he who asks good questions, not he who gives good answers
|
|
|
|
|
|
If all you want to do is move to the bottom of the page, you can make a link with a #LABEL as the HREF element at the top, then at the bottom add an anchor with the NAME attribute set to "LABEL". Or,
<A href="#enter">Edit Here</A> at the top of the page, then
<A name="enter">
<INPUT blah, blah, blah>
.
.
.
<INPUT more blah>
</A>
down near the bottom where you want to redirect the user.
If, instead, you want to put the cursor in the first input field at the same time, you need to do a little scripting. Example[^]
"Another day done - All targets met; all systems fully operational; all customers satisfied; all staff keen and well motivated; all pigs fed and ready to fly" - Jennie A.
|
|
|
|
|
OK, so I have this website that I started back in July or so and I want to update it's look. My web programming skills are limited and I don't much like web programming either but I may as well learn some more. I was wondering if anybody would bother looking at my site GP32US.com[^] and make some suggestion for its look and some tips on what to research to make it look better.
I really want to make it a good looking site and to try and attract more attention to it I'm not looking for real advanced programming or anything huge where I may as well be a web developer for a career (I don't), just some nice things to rearch to spice up my site a bit. I do the coding by hand mostly and I don't mind that because I wouldn't pay for an overly expensive development/office suite (Front Page or InterDev), so I may as well do it all by hand.
I remember someone suggestion a book once on web design and code, but I can't think of it anymore. I wish I had bought that book way bakc when I asking for suggestion on webhosting and such back in like July or August.
Anyways, thanks for any help you may be able to give me.
Who am I?
Currently: A Programming Student trying to survive school with plan to go on to Univeristy of Advancing Technology to study game design.
Main career interest include: Multimedia and game programming.
Working on an outside project: A game for the GamePark32 (GP32) portable gaming console.
My website: www.GP32US.com
|
|
|
|
|