Search results for query: *

thanks for the reply....i ended up using the replace function because the folder path is generated dynamically objFile = replace(objFile, "v.jpg", "") objFile = replace(objFile, objFolder & "\file", "")

i have a string like: \\folder\folder\folder\folder\folder\folder\210000\213790\file911723v.jpg i would like to strip it down to return just 911723. would my best be using the REPLACE function? Thanks in advance

BTW: i've referenced http://www.tek-tips.com/gviewthread.cfm/pid/248/qid/877947 and many other sites with no luck

I have a dynamic page that I want to be centered vertically in the broswer. I've tried v-align(ing) the outmost table by using code in the HTML and CSS with no luck. I've also tried putting the parent table in a div tag and v-aligning that...NO LUCK! Only thing that I've found to work was...

i need help using a repeater to basically simplify the following code: Case "district" distance = 5 Dim schoolDistrict As WTL.NeighborhoodData.SchoolDistrict() schoolDistrict = _neighborhood.GetSchoolDistricts(distance)...

i'm using the process class, and it looks like everyone has FULL CONTROL over the exe and folder where the pdb file will be created. Thanks again,

i'd wish to view the error i'm receiving when i'm trying to run an exe on the server that writes a file to the server. where i'm getting hung up is if i don't have rights to the exe from the aspnet user, or if i don't have write access to the folder where the file will be written. i'm also...

NM....think i got it ;-)

string username = txtusername.ToString(); string password1 = txtpassword.ToString(); string email = txtemail.ToString(); string query = "insert into [User] (UserName, Password, Email) VALUES (" + username + ", '" + password1 + "', '" + email + "')";

Thanks nigelrivett, but I ended up using the DATEDIFF function.

Show shipped sales within the past (DDL otpions: 1 7 30 60 90 180 All) days how will i go about the SQL statement? SELECT * FROM orders WHERE (shipping_status = 'shipped') shipped_date is what i'm wanting to compare against..... so will i have to get todays date, and -180 if...

do i have to use parameters to pass data into a SP? i'm trying to take a date value from a drop down list and running a query based on that date.

can you round a sum SELECT payment_method, SUM (subtotal) FROM orders group by payment_method order by payment_method

what exactly is this all doing? declare @Total int, @counter int, @cost int, @PartNum int declare myCursor Cursor Local for select PartNum, cost from Inventory open myCursor select @total = count(PartNum) from inventory set @counter = 1 while @counter <= @total Begin fetch...