In an applet I got this error-message in a Java-s system window. What could be the problem? Grateful for comments.
java.lang.StringIndexOutOfBoundsException: String index out of range: -13
at java.lang.String.substring(Unknown Source)
at...
I needed to use ' signs also around a double variable to make SQL accept a double with more than one decimal. Strange! Should I always use ' around my variables?
Maybe parameters then, but I think my code will work on my local database.
Thanks!
/Magnus
Hm, it works when I do it like this and put 'signs around the double variable:
StrSQL = "INSERT INTO Table1 (A, B)" & _
" VALUES (" & integerA & ", '" & doubleB & "')"
The 'signs seems to be a somewhat magical solution. Should I always have ' around my variables?
Maybe this is a VB question...
That is I can enter a number with more decimals directly in the table, but it doesn't seem tom be possible to send it from Visual Basic. Hmm...strange...
Hi! There's only room for one decimal though it says 'data type double' in the SQL table. I don't use a server, only a database on my computer. I will try your suggestions. Thank you!
Hi! I send a double variable from VB.NET code to a SQL database on my own computer. There seems to be a problem when the double contains a lots of decimals. This prevents the variable from being sent. Is it possible to change the allocated memory space for the double in the database or do I have...
Thanks again! This also seems to work:
StrSQL = "INSERT INTO FyllTid (A, B, C, D, Time1)" &
" VALUES (" & a & ", " & b & ", " & c & ", " & d & ", '" & time1 & "')"
The ' signs around time1 does the trick!!
Thanks!
Hi again!
The variable name is not the problem. Sorry for troubling you with that. No debugging error messages. I will look up SQL injection. Thanks for your time so far! Thank you very much!
Hi!
SET DATEFORMAT mdy
is not allowed by the build error manager in VB.NET.
The database is local on my machine. Could the localization still be a problem?
I'm still struggling :)
Hi! I have trouble sending a DateTime variable from VB code to a SQL database DateTime field. I use this:
StrSQL = "INSERT INTO FyllTid (A, B, C, D, Time)" &
" VALUES (" & a & ", " & b & ", " & c & ", " & d & ", " & time & ")"
Time is DATETIME in SQL and time is DateTime in VB.NET. What could...
I have put some activex components on a form and made an application. Now I want an executable file that will run on another computer. The activex components are installed on the other computer. If I do 'build solution' (I use VB.net) I get a .exe file but that don't run on the other computer...
Thank you DrJavaJoe for your answer! I just - maybe - have found a way to work around this problem, but I ask you anyway - how do I hook a window? Thanks again for your time. Thank you very much!
I'm not sure that this is what I need but maybe. Thanks! What is the exact workings of this code?:
<meta http-equiv="refresh" content="5; url=http://www.example.com/noscript.asp"/>
For me it is important that the redirecting web page will be omitted from the browser history folder - as is the...
Thank you shaddow! I use som scripting statements in my HTML. But if the user has scripting turned off I want him to be redirected instead with no trace in history. Since this won't work:
<noscript>location.replace(...)</noscript>
I hope I can use ASP and <% Respons.redirect %> instead. I...
Thank you Genimuse and Bullschmidt for your time and answers!
But can I do something like this then?:
<%
If (Active scripting is turned off on the client computer)
Then
...
End If
%>
Hope one of you or someone else has some ideas! Thank you very much!
Hello! I use a WebBrowser control. I use WebBrowser.Navigate to open a web page. The usual IE right click menu is displayed when I right click over the page. Can I disable the right click menu directly from Visual Basic? I'm very grateful for comments!
Hi! I use a WebBrowser control. I use WebBrowser.Navigate to display a web page. The usual IE right click menu is displayed when I right click over the page. Can I disable the right click menu directly from Visual Basic? I'm very grateful for comments!
Will this work?
<noscript>
<% some ASP code %>
</noscript>
Or will the ASP code be carried out under all circumstances - i.e. also when HTML code between the tags would be ignored?
How can I otherwise make ASP dependent on HTML events?
Very grateful for comments!
Hi again! This seems to work wich I found in another thread:
<%
t=timer()
sec = 60 'Number of seconds to pause
while(t+sec > timer())
'do code
wend
%>
Should I put the server.scripttimeout in the beginning? How do I write? Thanx!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.