Hello again,

Can't seem to get some of my columns to display on my detail page. I have a date requested column that displays fine but a date needed that does not display. I also have a userID that does not show. Cant quite find a commonality between the columns that do show and columns that don't. I also made sure that there is data in them.
Also, all these columns are being pulled from the same table.

Any ideas? <img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>

Thanks in advance.

hmmm strange,

All i can think of is your sql query, certain its selecting all required fields by name properly
or you running SELECT * ?

mine did that once, but dont want to go down the embarassing track
of font the same colour as background "ahem" <img src=../images/dmxzone/forum/icon_smile_blush.gif border=0 align=middle>

I'd recommend duplicating the Recordset, for fun, and having that display and see what you get.

you tried that before when having a niggle?? Or just for fun
<img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>
ps, you like the font colour one, i tried to strangle myself
when i realised LoL <img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>

My query is selecting all required fields so I'm sure that's not it... color font you say... hmmm. <img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>
I'll try duplicating the recordset also. I'm going in... wish me luck!!

i dont want no mickey taking, i was having a seriously bad day <img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>
shoes on wrong feet and everything ha ha ha "just kidding"

Slow down GH1, this yank is having a hard time interpreting the slang. Took me long enough to realize what carling was on my last posted topic. <img src=../images/dmxzone/forum/icon_smile_blush.gif border=0 align=middle>
Okay, the plot thickens! I did create another query and was able to pull the columns that I could not pull from my first query. What the...? I don't mind having two recordsets but is that wise (or normal)? Will it slow down the application if I put too many queries? Should I seek professional help? Would running around with scissors do me good?

sorry for the slang jeff, geordie language is far from speaking
proper england <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Im very interested in what chris has to say about this little dilemma you're having
you learn something everyday dont ya,

As for the scissors? i dont know, could help. i know someone who
goes through a mouse about once a fortnight, and nails them to his wall
above his computer <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>...this yank is having a hard time interpreting the slang...<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
This yank too, hehe.
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>Okay, the plot thickens! I did create another query and was able to pull the columns that I could not pull from my first query. What the...? I don't mind having two recordsets but is that wise (or normal)? Will it slow down the application if I put too many queries?<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
No, use only the one that works, otherwise unnecessary database/server calls. Clean it up yo!
<b>always keep a backup file</b> (like copy the file and rename to .old or something along those lines)
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>Should I seek professional help? Would running around with scissors do me good?<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Hmm, I think not! Just run on the Autobaund (spell-check has the day off).

~~~~~~~~~~~~~~~
Chris Charlton

Sr. Developer - www.fingerprintMedia.com

Edited by - ccharlton on 13 Jan 2005 01:37:47

Take a bow Wicked Member Chris!
What do you think sir? You think its okay to have two or probably more recordsets (I say more because I am not done with the detail page yet) just to fill out one detail page?

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>...You think its okay to have two or probably more recordsets (I say more because I am not done with the detail page yet) just to fill out one detail page?<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
More than one Recordset is totally fine, and even needed for dropdowns/form elements, etc. But just don't have two that are the same/pull same data.

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>Take a bow Wicked Member Chris!<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
<i>"I've taken my bows
And my curtain calls
You've bought me fame and fortune
And everything that goes with it
I thank you all
But it's been no bed of roses no pleasure cruise
I consider it a challenge before the whole human race
And I ain't gonna lose
And I need to go on and on and on and on"</i> -- Queen (We Are The Champions)

~~~~~~~~~~~~~~~
Chris Charlton

Sr. Developer - www.fingerprintMedia.com

Thanks for the Info Chris... and thanks for the lyrics to We Are The Champions too... I've been wanting to search for the lyrics but now I dont have to. <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

You are truly a Wicked Member... Hey can I change my status to Slacker Member? If it wasn't for you guys I'd still be working on my login page. <img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>

Thanks again y'all!

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>Thanks for the Info Chris... and thanks for the lyrics to We Are The Champions too... I've been wanting to search for the lyrics but now I dont have to.<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
You're welcome. I know you wanted the lyrics, I could sense it.
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>You are truly a Wicked Member... <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
My head just got bigger! Haha.
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>Hey can I change my status to Slacker Member? If it wasn't for you guys I'd still be working on my login page.<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
I wanna be Jedi member, so I guess we'll just nickname eachother <i>Slacker</i> and <i>Jedi</i>...if we had our own movie it would be <i>Slacker & Jedi Strike Back</i>.

Damn it's early in the morning. <img src=../images/dmxzone/forum/icon_smile_tongue.gif border=0 align=middle>