Search results for query: *

chiph, thank you for the syntax help. I did not know about the .Append feature, and while I could've done it as a paramterized query, I was having trouble with that as well.

I'm retrieving records from an Access database based criteria being passed from a search form, and in vs.net I'm getting the purple lines under the three form fields in my dynamic SQL string. Const strSQL As String = "SELECT * FROM Client WHERE ClientName LIKE '%" & frmName.Text &...

Thank you for the info. I don't know the syntax for the CONVERT() function, but the date format in CF works all the same. Just wanted to make sure I wasn't missing any crucial information.

Is there a way to have a formfield of european date formatted text be stored as such, so it outputs in the sameformat? When I output it from the database it's reversing the month and day back to US standard.

Is there a way to store dates in SQL 2000 in european format?

Thank you! Exactly what I was looking for.

How does ASP handle listbox values when passed through a submitted form? Does it create an array or list of the values. I'm going on the fact of my dropdown allowing multiple selections. How would the syntax for it look, too?

You can't? I read on an online ASP site that wildcards were allowed in such a statement. How else could you delete the entire contents of a folder without creating an array of all the filenames, then deleting them?

I'm receiving a very strange error when trying to delete files from a certain folder. On a template called purgefiles.asp, I have a line of code to delete everything from a folder: fs.DeleteFile("w:\inetpub\wwwroot\images\*.png") However, when I execute purgefiles.asp in the...

Holy mother of God. The cInt() function worked for it. Many, many thanks. Now it works like it should.

Nope, that didn't do it. Still loops past 48. My new code: *totalpages is assigned dynamically by a url value, but I'm merely re-referencing it again in here. <% totalpages = totalpages startPage = 1 endPage = startPage + (maxPage - 1) For i = 1 to totalpages If endPage >=...

Oh, no. It's not working properly. Now it's really frustating. I entered your code exactly the way you posted it. When I have 'totalpages' declared at the top like you do with an integer, it works fine. But, if I assign it's value to itself again (totalpages = totalpages), the loop doesn't...

Yes, it did work. And it's touched up a bit nicer, too. Thanks for the assistance.

Actually, there is a slight tweak to that If condition. This is what it should be: If a >= b then a = b End If The value of 'a' will appear up until 'a' equals or exceeds the value of 'b', at which time I want the value of 'a' to always equal the value of 'b'. My problem is this If...

I have a For...Next loop around some HTML code for output, and just before the response.write line, I have an If condition to alter the output for one variable when the condition is met. totalpages = 48, maxpage = 5 (just for your reference) <% startPage = 1 endPage = startPage + (maxPage - 1)...

When a user exits a certain page, I want all the images they uploaded to a particular folder to delete automatically, whether by the onUnload javascript, or some ASP/VBScript combination. Thanks in advance.

Set fs=Server.CreateObject(&quot;Scripting.FileSystemObject&quot;) if fs.FileExists(&quot;c:\Inetpub\wwwroot\blah.png&quot;) then response.write(&quot;<img src=blah.png>&quot;) end if set fs=nothing Adjust accordingly.

I have the full URL path, but what function can be used to take that URL path and request it to download that remote image to your server?

This is a slightly more accurate description of my previous posts, since I goofed on the terminology which I think threw some of you off. How can I upload images from remote servers to my own server? Do I need a full URL path for the image I have to upload? Plus, can image types be...

Is there a way in ASP to convert an image's type on the fly? For example, I have an IMG tag displaying an image from a remote server and need to change it from JPG to GIF. Can this be done? And if so, how?