| |
| |
| |
|
Page: 1 2
Comments:
<0> looks like you have two arrays to me
<1> ok how can i make this dynamic
<1> Dim USERARRAY(22, 1)
<1> i have a count on my records called sRecCount
<1> but this Dim USERARRAY(sRecCount, 1) gives me an error
<1> tells me it expects a number
<2> CInt(sRecCount)
<2> try that
<3> Dim movetodotnet
<3> Redim preserve movetodotnet(sRecCount,1)
<3> could be what aller is saying thouhg
<1> cint does not make a dif
<3> nope
<3> you need to do what i said
<1> now i get an error later in my page that I didn't before
<3> FuzzyLogi sounds like you got a lot of bugs =)
<1> Dim USERARRAY(22, 1) works great
<1> the rest of the page works fine with it
<1> but if i change that do anything so far i get probs
<3> Dim fubar, aryFubar()
<3> fubar = 1
<3> ReDim Preserve aryFubar(fubar, 1)
<3> WScript.Echo fubar & ":" & UBOund(aryFubar,1)
<3> that is your problem on dynamically dimension
<3> whether or not your variable has the right value (22)
<3> is another matter
<1> nevermind i have to pay more attention
<1> i put in Redim preserve movetodotnet(sRecCount,1)
<1> should have been Redim preserve USERARRAY(sRecCount,1)
<3> i think movetodotnet is more appropriate
<1> i got what you were saying after
<1> thanks for the help
<2> anytime
<2> (from loonatik)
<4> Hi guys.. I have iis running.. with ASP, I setup anon account, its giving me HTTP 500 Errors, any ideas?
<5> anyone knows a good free asp forum to use on a site?
<2> snitz
<2> http://forum.snitz.com
<5> is MegaBBS ASP Forum good?
<6> Wtf happened to schemas.microsoft.com!!!
<7> @find milf
<6> Hey guys, anyone know I would be getting an error with this mail script? http://rafb.net/paste/results/7AKBLQ86.html
<6> error '80040211' line 68.
<6> mail.send
<8> anyone have a tutorial on reading in an excel spreadsheet?
<9> rogers: google excel odbc
<8> yeah been trying to follow this: http://www.geekpedia.com/tutorial143_Extract-data-from-Excel-Spreadsheet-using-ASP.html
<8> gives me an error
<8> [Microsoft][ODBC Excel Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x167c Thread 0xbe8 DBC 0x15fd21c Excel'
<8> do I have to have something installed server side?
<9> hmm, i'm not sure.
<0> sup mute
<9> [Microsoft][ODBC Excel Driver]General error
<9> sup MadAtWork
<9> oops
<9> rogers: http://p2p.wrox.com/topic.asp?TOPIC_ID=25016
<8> thanks
<2> MadAtWork; are you never HappyAtWork ?
<2> :D
<0> Aller: didn't you ask that like 4 years ago?
<0> yah, i like my new job
<0> just trying to get a grasp of everything is taking a bit
<9> still new?
<0> i'm 3.5 wks old now
<0> i like the pay, i like the people, i like the management...
<0> wait.... it's too quiet...
<9> i didn't know you just got a new job, congrats
<9> what are you doing now?
<0> danke
<0> same
<0> i'm the it inclined person for our company
<0> there is an IT department for the rest of the corp.
<0> i'm responsible for our servers and teh production code
<0> moving more towards development also
<0> actually about to work on a custom UI for report services
<0> wee _-_
<2> lol MadAtWork - don't think i asked that 4 years ago, but if i did i'm sorry :/
<0> i'm sure some someone did
<0> no matter
<0> i'm no longer sitting under an ac unit in a closet office
<0> i'm happy
<9> nice
<8> ok finally figured out how to read in the excel spreadsheet... now some of the values are blank and its messing up the table. How can I check to see if the value is empty before entering it in the table? I tried If RS("office") = NULL Then Response.Write ("blah") End If
<8> I think there is data being pulled so its not null, but its not anything either, lol
<10> in mssql2k5, how can I disable recursion when I UPDATE inside a FOR UPDATE trigger?
<11> in a web textbox, how can i append something to the textbox where the cursor is at? Ther'es no AppendText
<9> superware: that should be automatic
<10> I've enabled trigger recursion on the db...
<12> so...in xml (there are no non-idle xml channels), when I declare a namespace inside of the <bookstore xmlns:somens="..."> does that mean that "inside of the bookstore node, references to 'somens' are talking about this namespace" ?
<0> this is looking pretty tight
<0> i've got awstats running for web stats, i'm using prtg for traffic and cpu stats
<0> now i just need to get a sensor for the sql stats or another program that might trac sql stats better
<1> what is wrong with this in my sql statement? SELECT TOP 500 SiteUsers.UID
<1> that looks fine to me but mabey not?
<1> I take out the top 500 it works fine but with it i get an error
<1> also this is a mysql database does that make a dif with the top 500 statement
<1> anyone?
<1> join #mysql
<2> select * from Siteusers.UID LIMIT 500
<2> mysql uses a different method of limiting results
<2> afaik
<0> FuzzyLogi: when you pasted it i didn't see a from
<1> i didn't post a from
<1> the rest of the statment is fine
<1> works great just the top 500 is giveing the prob
<1> and limit is giving me a prob also
<1> here is the whole statment that works
<1> SQL = "SELECT SiteUsers.UID, SiteUsers.ZipCode FROM SiteUsers SiteUsers WHERE SiteUsers.ActivationDate <> '' AND SiteUsers.DeactivationDate = '' AND SiteUsers.UserName LIKE '%" & Request("txtUSERSEARCH") & "%' ORDER BY ActivationDate Desc "
<0> *
<0> er
<1> the reason i'm using the siteUsers name is because i will be adding in another table to select from in this sql statment
<0> what rdms?
<1> and yes i know the FROM SiteUsers Siteusers could be just From SiteUsers
<1> rdms?
<0> what relation database management system
<0> i don't usually use that abbreviation, just popped out
<1> i'm using MySQL
<0> the query syntax should be pretty much teh same
<0> er the same
<1> i know but the top 500 and limit 500 does not seem to work
<0> well, take his advice
<0> #mysql
<0> maybe they'll see something we don't
<0> but i'd typically write that as selct top 500 siteuser.uid from siteuser
<0> so if that's not working something else is going on
<1> hmmm
<1> i got it to work
<1> but strange i have to put it after my order by
<1> if i put it anywhere else in my string no go, but after my order by statement it works fine
<1> is that standard?
<2> what's working? top 500 or limit 500 ?
<0> select blah from bleh where blah=pfft order by crap
<0> is typical
<0> so you're saying with mysql you have select blah from bleh where blah=pfft order by crap limit 500
<1> yep
<1> limit worked aller
<1> but has to be in madatworks format
<1> just seems strange to me
<2> and it's standard for mysql, sorry i didn't notice it before :S
<1> frg'n linux guys make everything more difficult
<0> not necessarily, does the top statment really make sense?
<0> the more i think about it, i like limit better
<0> i mean, logically, i think that's how it's going to work anyway
<1> ok i'll give you that top does make sense but limit does make more
<1> for some reason I was thinking limit was a 2 peram thing though
<1> something like Limit 0, 500
<1> start at record 0 returned till 500
<2> it can be a 2 param thing
<2> you can limit 100, 200
<1> ya i just tried it
Return to
#asp
or
Go to some related
logs:
FTGL VS2005
#nhl
cmd netcard disable
kr10i
#online
#nhl
suse 10 smb umount
#beginner
#beginner
#gamedev
|
|