Type: Posts; User: Bill Wilkinson
Search took 1.24 seconds.
I presume you aren't seeing any error from WriteAllText(). So weird. Well, you know, what you are doing in your working code is undoubtedly nearly identical to what wrterAllText() does behind the...
Just for grins...
string FilePath = Server.MapPath("~/Files/");
string fname = FilePath + FileName;
And use the debugger to find out what the...
It's called CDOSYS.
There are *TONS* of options with it. And even the simplest is more complex than CDONTS.
But it's not too hard for simple tasks.
Here's the skeleton of what I use:
You could create your own database-based "session" variables. Same as ASP.NET can do it. Otherwise have it work as do normal session variables: Encrypt the key to the session and put it in a...
You can *EITHER* use aliases OR just use the table names. Aliases are for convenience, only.
For this query, though, where the heck does the table names (or aliases) "consnr" or "a_buyer" come...
This part makes no sense:
' WHERE content_id = ' + cast(@rfid as nvarchar(100))
Assuming that content_id is an INT field, then why would you want to compare it to an NVARCHAR value? SQL Server...
Cursor to memory is just RS.CursorLocation = adUseClient
I think adUseClient is 3.
Okay. Are you aware that a recordset can be disconnected? That is, after you have the recordset in memory (you have to move the cursor to memory to do that...I forget the exact code, as it's been...
It really depends on your real world. In the simple example you gave, where you use ORDERS and CUSTOMERS, it is clear that there MUST be a customer record for every order record (and of course could...
SHAME ON ME! i utterly missed the fact that you are using two different DB systems!
You know, there might be a way to do this pretty efficiently! Even the sort you wanted, at the end....
SUGGESTION: Never use a DB field name "ID".
Instead, always prefix "ID" with the name (or shortened name) of the table.
Thus I would have custid in the customers table and orderid in the...
NEVER use a SQL query inside of any kind of loop. Learn to build more complex SQL queries.
And use SQL to do your sorting/ordering.
SQL = "SELECT O.id, C.customer_name...
This code is also so very old that it's nearly ancient. It really needs a complete rewrite. And a *LOT* of simplification.
I think you are doing it all wrong.
Your function checking_icaptca() is a waste of code.
You are already setting SESSION("code") so just let "save.asp" check that against the user's code value...
And would you care to show how? Remember, using ASP code, only.
That should read
= '" & search & "'" at the end.
Maybe like this?
SQL = "SELECT * FROM sometable WHERE LEFT(somefield," & LEN(search) & ") = '" & somefield & "'"
But I would bet that if you go back to ".mdb" that the % will start working.
You can try, but you'd almost surely get more and better answers in an Oracle-specific forum.
Did you try saving the database as an old-fashioned ".mdb" file? So far as I know, JET doesn't really understand ".accdb" files. There's no advantage to saving in the latest format, in any case. ...
Why did you use Request.QueryString instead of
That query string is only going to work if you see
The answer is actually (sort of) on this site. Wasn't easy to find, but...
There, he is running the batch file "ping.bat" from ASP code. ...
I would *GUESS* that the valule of attribute is:
(a) wrong. Maybe you are using a relative path that is wrong. Maybe you should be using an absolute path (that is, starting with a / character). ...
Ignore the blue line. What happens when you RUN the code?
Anyway, I don't understand this sequence, *AT ALL*:
Dim Sql As String = "SELECT strEmail FROM university (strEmail) WHERE...
Well, the docs say that the value returned is a LONG (long integer).
But VBScript does not support long integers. (The CLNG() function only produces 32 bit integers, which were long integers in...
Do you want the answer in SQL or in VBScript code?
It's nearly the same thing.
diff = DateDiff("s", starttime, endtime )
diff = TimeSerial( 0, 0, diff )