Comments by memberxxxxxxxxxxxxxxxxx (Top 20 by date)

i had something completely different in mind lol. but stress relief is always good.

i could use stress relief now :P, i tried collapsedsize...nothing :(

ok, made the changes, you suggested and i also added something as a test.

if you look in the page_load...i added lines to have one panel collapsed on load, and the other to be open. just wanted to see how it works...nothing. both panels still open on load.

i've edited the original post to reflect the code as it is now.

thanks for the help btw, turning those bowls? lol

didn't seem to do the trick. i swear though...if that fixed it i was gonna go home for the day lol.

i did add the autopostback property in the html though, that ok? or does it have to be in the codebehind?

i suspect the problem has to do with my if statements and/or my radiobutton values. in the html, i have the values set as 1, and 2 and in the codebehind i used those values in the if statement, not sure if done properply?

soryr it took so long for me to get back to you thank you for the help. really appreciate it

doesn't seem to make much of a difference.

i guess a question now is...and this really makes no sense to me...
can i send in a "varchar" to a sproc to retrieve decimal values?

or better yet...can i even have decimal values as an output? do i have to pull them out as varchar and then convert? i don't see how i can even do that with the table structure as is.

thanks. appreciate the help. it's always the small stupid things that get ya

thank you very much!!!
so if i leave off the (5,3)...sql automatically uses precision 0? out of curiosity...why does the query "9.1" work in queryview, but not in runtime?

once again, thank you

honestly, i'm not sure. when building the table, i set the bc column as decimal(5,3) so that means 5 total numbers with 3 after the decimal for precision right? none of my bc values are more than 2 decimal places.

also, i just ran the program to the cursor and stopped here:
var dec = Convert.ToDecimal(TextBox1.Text);
cmd.Parameters.AddWithValue("@bc", SqlDbType.Decimal).Value = dec;*******cursor

i see that the var "dec" = 9.1 so it should give me the proper fileSymbol.

i then ran the cursor to here:

string outputValue = cmd.Parameters["@fileSymbol"].Value.ToString();
Label1.Text = outputValue;
and i see that the outputVal = "Q" which is incorrect.

thanks i appreciate the help. worked out just as you said. just needed to run it in a stored procedure

lol it wouldn't surprise me. basically, i have a table of people, one of the columns has their zipcode. that zipcode is tied to a zipcodes table that has the zipcode, city, state, latitude and longitude. i'd like to add a filter that retrieves people within a radius of a specified zipcode, but i'd like to be able to put in the radius and the zipcode.

so i found those functions and tried incorporating them in my site, but i don't know much about sql and ran into the wall.

like i said, i'm using vb web developer. there's a query designer that sort of allows me to test queries and input whatever for variables, but when i try to run the query, nothing happens, just returns the columns, but no data. if i take out the @Distance and replace it with a number...it works.

this is where i got the function:
http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/sql-server-zipcode-latitude-longitude-pr

i tried modifying the sample query for stores lol. not successfully though.

I was trying anything and everything i could to try to make it work. i tried the first one, not the second. it didn't work. my latest attempt was:

WHERE dbo.CalculateDistance(@Longitude, @Latitude, ZipCodes.Longitude, ZipCodes.Latitude) <= @Distance

and that didn't work.

i'm using vb web developer and trying all this out in the "new query" wizard. i'm expecting the query to ask me for a value for the distance, but it's not and simply returning an empty set. ie no rows, i know very little about sql so i don't want to get the terminology wrong.

i've left off the zipcodes part because that was another source of frustration. i've tried declaring it and replacing the '20013' with @zipcode, but i kept getting an error saying that i had to declare the scalar variable even though i declared it right under the declare for the lat and longitude

thanks.
i added a new parameter:

com.parameters.add("@playerPay", sqldbtype.decimal).value = playerPayTextBox.Text;

this doesn't seem to work, i get the following error:
"Error converting data type nvarchar to decimal."

so then i tried this:
com.parameters.add("@playerPay", sqldbtype.decimal).value = playerPayTextBox.tostring();
i get the same error:
"Error converting data type nvarchar to decimal."

which makes sense, so then i tried:

com.parameters.add("@playerPay", sqldbtype.decimal).value = decimal.parse(playerPayTextBox.tostring());
error: "Input string was not in a correct format." - then the datetime thing...

com.parameters.add("@playerPay", sqldbtype.decimal).value = decimal.parse(playerPayTextBox.text);
error: "Input string was not in a correct format." - then the datetime thing...

not sure what to do

thank you for the help.

thank you. i am curious, i thought this method opened up the possibility of sql injection attacks?

thanks for the help.

first time i tried it, i didn't have the ' near the select and at the end...so it said incorrect syntax near the select.

second time i put the little quote marks in and now it says...
"The data types varchar and varchar are incompatible in the modulo operator."

as i understand it, datasets are old school, but i've been following the data walkthroughs...i'm learning lol.

i made the tableadapter using sql statements. does this method still work for that?

for added info...when i made the adapter using the dataset wizard, it says that the DECLARE sql construct is not supported.