Forum: MS SQL Aug 16th, 2005 |
| Replies: 10 Views: 11,197 try doing your calculations before your sql statment
Dim i As Double
Dim MySql as string
i = 50 / 100
Mysql="Select " & i & " FROM table;"
rs.open MySQl,conn,3,3,1 |
Forum: MS SQL Jun 16th, 2005 |
| Replies: 1 Views: 20,091 Haven't used Vale Software, but try this.
open ms access and link to an ODBC datasource to the sql tables you need to see if all is ok.
I often use this method to quickly modify the sql tables... |
Forum: MS SQL Jun 16th, 2005 |
| Replies: 2 Views: 3,214 you will either need to add a second table to keep track of document names and Document numbers relations or add a DocumentName Column to your table. |
Forum: MS SQL Jun 16th, 2005 |
| Replies: 2 Views: 18,326 Views are basically a few tables group together by a server side query.
would return only Ford = Yellow
select * from X where Car=’Ford’ or Color=’Yellow’
would return Alfa Yellow
Volvo... |
Forum: MS SQL Jun 16th, 2005 |
| Replies: 4 Views: 3,116 Are you inserting a table or a record? If you are trying to insert a record the table amy have been created with an requirement of one or more of the fields. |
Forum: MS SQL Jun 16th, 2005 |
| Replies: 10 Views: 11,197 change the resulting variable to type double |
Forum: MS SQL Jun 16th, 2005 |
| Replies: 10 Views: 116,565 Mad Max
colum name = id
data type = int
down at the colum properties box change
identity to yes
identity seed to what number you want to start using
identity increment to how much the... |
Forum: MS SQL Jun 16th, 2005 |
| Replies: 1 Views: 6,019 post a couple of lines that include line 151 from userUpdate_submit.asp and we'll see if that will help us help you. |
Forum: MS SQL Jun 16th, 2005 |
| Replies: 2 Views: 10,147 here
http://www.databasejournal.com/features/mssql/article.php/10894_2197931_2
this link should put you on the right path |