Help!!!!

[FlashNobster]

I Don't know what im doing wrong!!!
I created a record update form, but is not working correctly... I can get to the form fine, but when i click one the update record button i get this...
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

--------------------------------------------------------------------------------

Technical Information (for support personnel)

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE




Any suggestions on what i'm doing wrong will be really appreciated greatly.

Thanks,
FlashNobster Oh also dreamweaverNobster

 

[sirjon]

Check the update statement carefully, especially the data type, make sure this corresponds with the data type in your DB.
HTH

 

[Cheech]

Responsw.Write your update statement to the screen before it executes to see exactly what it is trying to do.

Cheech

[Peace][Pipe]
If you don't stand up for something, you'll fall down. Toke it Easy.
Howard Marks.

 

[lebisol]

u already got the suggestion:
-Syntax error in UPDATE
next:
post code... THE SQL part please
SELECT Blah_UP WHERE blah ="soma-coma"....


then we can see what's up with your app
All the best!

> need more info?
:: don't click HERE ::

 

[FlashNobster]

This is the rest of the error...


Technical Information (for support personnel)

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
/lobo_negro/New_Folder/TMPnlozpeltw.asp, line 111


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.0.3705)

Page:
POST 164 bytes to /lobo_negro/New_Folder/TMPnlozpeltw.asp

POST Data:
Location=Thee+Parkside&Adress=1600+17th+Street+at+Wisconsin+Street%2C+San+Francisco%2C+CA&Phone=%28415%29+503-0393&Date=8+%2F16%2F2003&MM_update=form1&MM_recordId=1

 

[FlashNobster]

this is SQL Statement...

SELECT * FROM Gigs2

 

[Cheech]

My guess is reserved words in the sql statement. Date is a reserved word.

POST Data:
Location=Thee+Parkside&Adress=1600+17th+Street+at+Wisconsin+Street%2C+San+Francisco%2C+CA&Phone=%28415%29+503-0393&Date=8+%2F16%2F2003&MM_update=form1&MM_recordId=1

Cheech

[Peace][Pipe]
If you don't stand up for something, you'll fall down. Toke it Easy.
Howard Marks.

 

[FlashNobster]

Wow, That was it!!!!


In the DB I changed DATE to DATES and it worked. So, why in the DB, you can't give it the field name DATE?

Thanks.

 

[Cheech]

"So, why in the DB, you can't give it the field name DATE?
"

Coz some words are reserved. Dont know how accurate this is but

http://pacosdrivers.com/asp/reserved/

has a list of words that are reserved.

A good code of practice is to prefix your field names with fldNameOfField

Cheech

[Peace][Pipe]
If you don't stand up for something, you'll fall down. Toke it Easy.
Howard Marks.

 

[FlashNobster]

The site works fine, until i try to use the "REPEAT REGION"


I get this:
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

--------------------------------------------------------------------------------

Technical Information (for support personnel)

Error Type:
Microsoft VBScript compilation (0x800A0411)
Name redefined
/lobo_negro/TMPal7vgmb8pa.asp, line 26, column 4
Dim Repeat1__numRows
---^


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.0.3705)

Page:
GET /lobo_negro/TMPal7vgmb8pa.asp

Time:
Sunday, October 05, 2003, 5:43:59 PM


More information:
Microsoft Support



I selct the rows in my table then apply the repeat regions and then it no longer works. What am i doing wrong?

 

[TruthInSatire]

Gotta love software that writes code.

Sounds like MM is trying to do the same thing twice. is the VAR Repeat1__numRows defined somewhere else in the page? Its hard to help when we can't see any code. is this the only place you're doing a repeate region? can we see the code?

http://thereptilian.com/

 

[llldnylll]

I messed with it for a while and decided to start from scratch, which fixed the problem.

I have another question though...
If I have a table with 3 rows and 3 colms, how can i get 1 border around the whole table? instead of each individual cell.

Like your site

http://thereptilian.com/

the Premiere Classified Ads table

 

[TruthInSatire]

You could do it a few ways
1) you could encompas the whole thing in a single cell table and give that cell a border (probably the easiest)
2) <table style = &quot;border: 1px solid #000000&quot;> (sometimes this gives a lighter boarder on the right and bottom)
3) you could give the outside cells a border.
<table>
<tr>
<td style = &quot;border-left: 1px solid #000000; border-top: 1px solid #000000&quot;></td>
<td border-top: 1px solid #000000&quot;></td>
<td border-top: 1px solid #000000; border-right: 1px solid #000000&quot;></td>
</tr>
<tr>
<td style = &quot;border-left: 1px solid #000000&quot;></td>
<td></td>
<td style = &quot;border-right: 1px solid #000000></td>
</tr>
<tr>
<tdstyle = &quot;border-left: 1px solid #000000; border-bottom: 1px solid #000000&quot;></></td>
<td style = &quot;border-bottom: 1px solid #000000&quot;></></td>
<td style = &quot;border-right: 1px solid #000000; border-bottom: 1px solid #000000&quot;></></td>
</tr>

http://thereptilian.com/