Search Results

Showing results 1 to 9 of 9
Search took 0.00 seconds.
Search: Posts Made By: jwshepherd ; Forum: MS SQL and child forums
Forum: MS SQL Aug 16th, 2005
Replies: 10
Views: 11,197
Posted By jwshepherd
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
Posted By jwshepherd
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
Posted By jwshepherd
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
Posted By jwshepherd
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
Posted By jwshepherd
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
Posted By jwshepherd
change the resulting variable to type double
Forum: MS SQL Jun 16th, 2005
Replies: 10
Views: 116,565
Posted By jwshepherd
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
Posted By jwshepherd
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
Posted By jwshepherd
here
http://www.databasejournal.com/features/mssql/article.php/10894_2197931_2

this link should put you on the right path
Showing results 1 to 9 of 9

 


About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC