Search:
Type: Posts; User: l12ngo
Search:
Search took 0.06 seconds.
-
Not really. Dictionaries are quick (usually more so than multi-dimensional arrays), powerful and have a few methods and properties built into them that are pretty handy.
Here's a link that lists...
-
You can do something similar by making a dictionary of an array element. I've tried taking a simple example and commenting it. If you just put all the code in an asp file it should work fine and you...
-
You may have more luck posting in the other forum seeing as you're using JavaScript:
http://www.vbforums.com/forumdisplay.php?f=11
Whilst a lot of people who come here probably do have some...
-
You could try using: Response.ContentType = "application/vnd.ms-excel"
Just google the term if you want to find examples of using it.
-
If you're getting the message Expected End, it would suggest one of your If statements doesn't have a corresponding End If. There is a problem however with the line you posted, you're missing the "...
-
The problem is still your sql string. In Access you use DAO to query the database, in ASP you need to use ADO to do your query. The code I posted would create a Table for you in ASP no problem, like...
-
It's probably going to be easier if you Order By city in your SQL statement. Then you just loop through your recordset something like:
<%
Dim rs, cn, strDSN, StrSQL, tempVal
set cn =...
-
If you're taking the value 5 from your page as a string and your providing this to your database (which is expecting an integer) then this will be you're problem. There are several functions...
-
I know this is a late reply, but I think I finally figured out what you're trying to achieve (I can be a bit slow on the uptake ;) ):
Const ForReading = 1
set fso =...
-
Although Access uses * for it's wildcards, you're performing a query using ADO so you still need to use %. I've just created a table in an access db called Projects with two values (one called...
-
This writes out html when I run it, if attach_name is changed to test.doc, it will print out doc:
attach_name = "test.html"
dim strURL,addURL
strURL = attach_name
addURL = split(strURL,".")...
-
Though this may or may not directly help you with this particular query, I've noticed you've been doing a lot of work with ADO recently. There are a few things I'd consider doing if possible.
1....
-
Have you actually set conn further up your code?
-
You could also do it this way:
varPath = "filelocation/images/myphoto.jpg" 'set variable to path
response.write mid(varPath, InStrRev(varPath, "/") + 1) 'display result
So if you were putting...
-
Could be the function (called go) you're trying to call onload. Does this function exist? Try removing the onload=go() bit from your body tag.
-
Okay, try this and let me know what we need to do from here. I've commented this script so you know what's going on:
Option Explicit 'thrown this in to keep track of my variables
' declare my...
-
If you're ever unsure about what type of variable you're pulling back from things then you can try using typename to help you out, so:
msgbox Typename(found_rows)
in this case.
-
No worries about things getting more complicated, it's usual to keep adding complexity to scripts as your needs develop so we're good there.
Now, there's good news and bad news. First the bad...
-
Yes, if you look at the line:
objSheet.Cells(i, j).value = file.name
j is a variable which is set to 1 in my code. i is another variable which is set to one, but is incremented by 1 each time...
-
Just seen this post and it looks like you've sorted it anyway, but this may help for in future:
Dim strToDo, re, matches
strToDo = "My CAR is a cAr and caR beside my Car is a cAR too"
set re =...
-
I don't know about .Net, but in Classic ASP you'd use Response.Redirect and Request.Querystring to grab the info from your URL. Your probably better off waiting for someone who knows .Net, but if...
-
Do you get a value if you response.write gpermohonan("id") after the first sql query (you can just throw in a response.end after it to stop the second query throwing up an error while you debug)? If...
-
Could try something like:
Dim fso, objFolder, obFileList, folderpath, fullpath, xl, i, j
folderpath = "C:\Test"
Set fso = CreateObject("Scripting.FileSystemObject")
Set objFolder =...
-
OK, I thought it was a line by line comparison you were after. As you seem comfortable using recordsets, this will read your text files into two different recordsets (rs & rs2):
Dim rs, fso,...
-
Try this:
Const ForReading = 1
Const ForWriting = 2
set fso = CreateObject("Scripting.FileSystemObject")
set objText1 = fso.OpenTextfile("C:\Textfile1.txt", ForReading)
set objText2 =...
-
The only way you can hide your DOS box is if you use Run method as opposed to Exec:
...
-
Your code looks like VB6, not VBScript/ASP. If you are using VB6, you'd probably get abit more help from the Classic VB forum. If you're using ASP, then I agree with the other poster that using...
-
If you're using the filesystem object anyway, you could use the delete file method:
objFSO.DeleteFile(strFile)
-
This WMI call works on my local PC:
Set colCompSys = objWMIService.ExecQuery _
("Select * from Win32_ComputerSystemProduct")
For Each objCompSys in colCompSys
Wscript.Echo...
-
Just use Request.Querystring. In your example, this would return the value me:
varUser = Request.Querystring("User")
Response.write varUser
-
This will search for all the files in c:\users:
Dim rs, fso, objFolder, obFileList
Const Maxchrs = 255
Const adVarChar = 200
Const adFldIsNullable = 32
Const adInteger = 3
Set rs =...
-
This should cope with null values:
strComputer = "."
Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\cimv2")
Set colItems = objWMIService.ExecQuery("Select * from...
-
Well, sometimes you can pull values back from a database and then you'd use something like:
If Not IsNull(x) Then
'do something
End If
where x would usually be something like...
-
It could also be down to the actual data you're passing to it. Say for example (just working with integers again), you've been passing order numbers to the app via your file, the app could be then...
-
I doubt it's a database problem with an overflow error like that, but others here would know more about the database side of things so I'll let them answer that.
Is CRF the full name of the...
-
It could also be because you're passing too much data in, so you could try splitting up a file if you have a huge file you're passing to it. For example, this would cause an overflow error:
Dim i...
-
msgbox Me.List1.List(1)
If you wanted to msgbox out the third item:
msgbox Me.List1.List(2)
Obviously this is assuming your list is called List1.
-
I'd probably try to look for a worse product to compare my app to. For example if I had an app that was used in Warehouse management, I'd probably use something like Popims (an old but still widely...
-
You could try using a WMI call for the Win32_Product class. It may pick it up in there. Thought I'd post an example:
strComputer = "."
Set objWMIService = GetObject("winmgmts:\\" & strComputer &...
-
Lol, it's just as well you asked your prof what HE meant by complexity cause it sure sounds like no-one else thinks that's what it means :)
That's one big report :D
The striking things out of...
|
Click Here to Expand Forum to Full Width
|