This topic is locked

Dal error

2/23/2009 11:42:58 PM
ASPRunnerPro General questions
C
Carrie author

I'm using this code in the "After successful login":
if (dal.Buildings.Value("Active_Status") = 0) then I think the err is here, cause if I take out the IF ENDIF, it works fine

dal.Buildings.Value("Active_Status") = 1

dal.Buildings.Value("LastSuperAccess")= Now()

end if
dal.Buildings.Param("BuildingLoginID")=Session("UserID")

dal.Buildings.Update()
I get this error
Error number 438

Error description Object doesn't support this property or method

URL /aspr_test/login.asp

SQL query select * from [dbo].[Buildings] where [BuildingLoginID]='supernanny' and [BuildingPSWD]='ynnanrepus'

Solution
The query works fine in MS SQL.
any help is appreciated.

Admin 2/24/2009

Post the whole event code here.

C
Carrie author 2/24/2009

Post the whole event code here.


Hi, I'm not sure what you are asking me. I've already posted the Event Code, but here it is again.
if (dal.Buildings.Value("Active_Status") = 0) then I think the err is here, cause if I take out the IF ENDIF, it works fine

dal.Buildings.Value("Active_Status") = 1

dal.Buildings.Value("LastSuperAccess")= Now()

end if
dal.Buildings.Param("BuildingLoginID")=Session("UserID")

dal.Buildings.Update()

I hope this is what you are looking for. As mentioned, if I remove the IF statement I get no errors.
Thankyou for the assistance.

C
Carrie author 2/25/2009

Not to worry. I figured after this much time with no response other than "Post the whole event code here...", which was done in the original post and re-plied to - with no response to!!!
SOOOO, I thought I'd check around.
I found the answer I was looking for in another forum.
But I do want to thank all the 71 viewers and 1 responder for the assistance.
Dal is great - actually potentially AWSOME!. The "DOCS ARE WEAK, the Help file and web docs are the same - just prettier.
Having said this, the forum I connected with costs a few bucks, but man are they attentive and responsive. LIKE WAY RESPONSIVE!!!
Great product, keep up the good work.
Yup, a little miffed here! Signing off forever.
Cheers...
btw:forum master/admin/guru, please delete my account as I won't be back, other resources are far more responsive.

O
Observer 2/25/2009

Boy is this chick miffed!
I've been observing and following this forum for some time. I find it to be riddled with code fragments and suggestions, which I believe are beneficial and helpful.
However, I followed one thread in particular (Carrie) and found her final (???) comments to be somewhat abrasive, yet far more polite and unreasonably fair than what I'd have done.
Let's follow the timeline of her particluar post:
Feb 24 2009, 04:42 AM - Original Post - CARRIE
Feb 24 2009, 04:25 PM - Asking to POST ALL... - Sergey Kornilov (sure seems like about 23 hours or so...)
Feb 24 2009, 07:05 PM - Post indicating already done. - CARRIE (about 3.5 to 3 hours...)
Today, 12:46 AM She's somewhat p1$$ed YES??? - CARRIE (seems to be alot longer than the reply from Sergey...)
I can diludge this forum with quantums of posts that have ZERO responses. Not even the courtesy of a reply.
As JAJA BINKS would say "HOW WOOOD???"
Not sure of what the timezones are like, but being here in the Western Zone, I can tell you that the timeline for responses or (more to the point) lack there of is dismal.
I looked at over 50 threads after reading Carrie's initial post and I gotta tell ya, it seems that the only ones that get help are "Registered Users". What about those folks that want to evaluate, try some things and get ZERO help.
Like this Roger guy. He's asked a few questions (he's new here as I can see) and offered up 1 piece of info. The Admin, responded that his answer was correct. As far as I can tell, he's gotten nothing from his query - but as a newbie he took the time to check into something (perhaps out of self interest or purpose - who know's? who cares?) and offered up his findings. Bet you he's learnt more about this product in the last 48 hours than most people would in a week.
Anyway, what's that all about? Why didn't Admin respond to the original request first??? Took a long time I might add to respond to this Roger guys reply - not the original post - hmmm...
Sorry all, but the timeline and the READS/RESPONSES are just not even close to fair. Do people just post here cause they can?
DO the supporters not want to help? Are they just here to excercise their own progies?? (yeah it's UKE!!!)
Hopefully this site can do better in the future.
Also, most posts that I've seen that are responed to by admin/pros of aspr - always seem to suggest "Post to Demo Account and yada yada yada...".
Why would anyone want to post to a demo site when they can't even get help here??? Free code samples perhaps.
Also, the examples in the Help File (as well as links to the DAL docs) are just soooo poor...
I love this product, I moved my company from asprunner and codecharge studio because it is excellent and robust. I can tell you from experience, that it took my company's developers many months to solve problems ourselves. We didnt' get a lot of help here. Check out WAZUP's and GOOMBA's posts. They are my people and they are great.
Some of the code they've developed using aspr is excellent - no absolutley asto0unding!
I think far more reliable than what comes form this forum. Example: changing FONT colors during a list event. ADMIN said in a post to use RS("..."). Roger helped with the suggestion to use strVALUE.
Hmm, a newbie figured this out and a seasoned vet didn't. Pause to wonder.
Thanks for letting me vent, my company will still continue to use this product and recommend to our associate devs, but you guys gotta figure out a better way to help YOUR users.
Cheers now <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=38262&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' /> <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=38262&image=2&table=forumreplies' class='bbc_emoticon' alt=':)' /> <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=38262&image=3&table=forumreplies' class='bbc_emoticon' alt=':)' />

R
Roger 2/25/2009
Admin 2/26/2009

Carrie and Observer, nice rants, thank you! I wish I had enough time to make posts that long.
Anyway, this is a free for all member-to-member self help forum. All customers that need support should proceed directly to http://support.xlinesoft.com. When Jane or I have some spare time we trying to help but there is no guarantee at all.
Back to work now.