PDA

View Full Version : Help with importing data using asp.net


NickMalloy
04-07-2003, 05:24 PM
I am trying to import data from a sqlserver using asp.net. My asp.net page
produces the following output below. In my flash presentation I am using
this code.

myData = new loadvars();

myData.onload = function(success){
if(success){
AZpropnames = myData.AZpropnames;
}else{_root.tester.text = "Failed to load data";
}

}
myData.load("http://www.americafirstproperties.com/flash/getprops1.aspx");
_root.tester.text = AZpropnames;

if you look right after succes=true below you will notice that I have
AZpropnames=Coral+Point+Apartments. In the code above I do not recieve the
"Failed to load data" error, but I also don't recieve text in my textbox.
Can anyone help me?

success=True&AZpropnames=Coral+Point+Apartments&AZxscale=125&AZyscale=125&AZ
propID=15013030112&CApropnames=Jackson+Park+Place&CAxscale=25+&CAyscale=100&
CApropID=15004050141&FLpropnames=St.+Andrews+at+Westwood%7cThe+Park+at+ Count
ryside%7cBelvedere+Apartments%7cClear+Lake+Colony% 7cThe+Glades%7cFairmont+Oa
ks%7cLakes+of+Northdale%7cLake+Forest+Apartments%7 cIona+Lakes+Apartments%7cO
akhurst+Apartments%7cMisty+Springs+Apartments&FLxscale=111%7c152%7c58+%7c158
%7c150%7c255%7c212%7c220%7c110%7c145%7c120&FLyscale=222%7c152%7c45+%7c145%7c
150%7c300%7c125%7c230%7c120%7c120%7c150&FLpropID=15011090144%7c15011090139%7
c15011090158%7c10011090154%7c30011090171%7c1001109 0174%7c30011090175%7c10011
090162%7c10011090153%7c15011090159%7c30011090118&GApropnames=Northwoods+Lake
+Apartments%7cMorrowood+Townhomes%7cHarmony+bay+Ap artments%7cLealand+Place+A
partments%7cLaurel+Park+Apartments%7cThe+Retreat+A partments%7cPark+Trace&GAx
scale=152%7c147%7c150%7c85+%7c110%7c125%7c45+&GAyscale=125%7c145%7c125%7c75+
%7c110%7c110%7c125&GApropID=10011100114%7c20011100110%7c20011100127%7 c200111
00160%7c25011100117%7c15011100140%7c15011100142&IApropnames=Valley+View+Esta
tes%7cAshley+Square+Apartments&IAxscale=75+%7c155&IAyscale=75+%7c145&IApropI
D=50015150176%7c10015150101&ILpropnames=The+Covey+at+Fox+Valley%7cVictorian+
Park+apartments&ILxscale=125%7c75+&ILyscale=52+%7c75+&ILpropID=15015130107%7
c50015130137&INpropnames=Ashley+Pointe+Apts+at+Eagle+Crest&INxscale=22+&INys
cale=65+&INpropID=10015140132&KSpropnames=Jefferson+Place+Apartments&KSxscal
e=100&KSyscale=150&KSpropID=15015160115&MIpropnames=The+Ponds+at+Georgetown%
7cAnn+Arbor+Harbor+Club%7cMonticello+Apartments&MIxscale=125%7c54+%7c110&MIy
scale=175%7c54+%7c160&MIpropID=30015220135%7c50015220130%7c30015220163&NCpro
pnames=Hunts+View+Apartments%7cFox+Hollow+Apartmen ts%7cDelta+Crossing%7cBluf
f+Ridge+Apartments%7cCameron+at+Hickory+Grove&NCxscale=100%7c258%7c155%7c145
%7c120&NCyscale=98+%7c250%7c456%7c25+%7c154&NCpropID=30011330168%7c300113301
28%7c30011330164%7c30011330169%7c20011330157&NEpropnames=Mayfair%7cThe+Green
house%7cJoslyn+Lofts&NExscale=125%7c78+%7c125&NEyscale=110%7c58+%7c110&NEpro
pID=50015270170%7c20015270155%7c50015270165&NVpropnames=Rose+Cottage&NVxscal
e=110&NVyscale=125&NVpropID=80013280152&OHpropnames=Highland+Park+Apt&OHxsca
le=110&OHyscale=115&OHpropID=30015350167&OKpropnames=Greenbriar+Apartments%7
cThe+Hunt+Apartments&OKxscale=120%7c85+&OKyscale=110%7c75+&OKpropID=15002360
148%7c15002360149&SCpropnames=Bent+Tree+Apartments&SCxscale=120&SCyscale=120
&SCpropID=10011400156&TNpropnames=Shelby+Heights+Apartments%7cThe+Park+a t+58
%7cOakwell+Farms%7cLittlestone+of+Village+Green+Ap ts%7cBrentwood+Oaks+Apartm
ents&TNxscale=125%7c120%7c145%7c100%7c120&TNyscale=120%7c150%7c110%7c125%7c1
52&TNpropID=15011420138%7c15011420133%7c15011420151%7 c15011420145%7c30011420
166&VApropnames=Waterman's+Crossing&VAxscale=45+&VAyscale=45+&VApropID=30003
460116

freddycodes
04-07-2003, 06:12 PM
Most likely because you try to assign the value to the text box before you give the onLoad handler a chance to run. Try this instead


myData = new loadvars();

myData.onload = function(success){
if(success){
AZpropnames = myData.AZpropnames;
_root.tester.text = AZpropnames;
}
else{
_root.tester.text = "Failed to load data";
}

}
myData.load("http://www.americafirstproperties.com/flash/getprops1.aspx");