Less carbs, lol. Recently saw a low carb bread. How can you have low carb carbs? Reminds me of low fat fat...

testing it and a blank database causes errors.
even after doing what you said.

Kerry, can you tell me _what_ errors you are getting?

Blog on Atkins! Wow...does that mean it'll trim useless messages like this one by 30 per <snip>

Raymond rocks! You answered my queries with lightning speed. Solved my problems. Thank you.

Brand new install, just calling the design mode for the first time and receiving this error.

Thanks.

Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 3.

The error occurred in D:\WebDocs\ScrapBookPortal\blog\org\camden\blog\blog.cfc: line 368
Called from D:\WebDocs\ScrapBookPortal\blog\includes\pods\calendar.cfm: line 50
Called from D:\WebDocs\ScrapBookPortal\blog\tags\layout.cfm: line 56
Called from D:\WebDocs\ScrapBookPortal\blog\index.cfm: line 148
Called from D:\WebDocs\ScrapBookPortal\blog\org\camden\blog\blog.cfc: line 368
Called from D:\WebDocs\ScrapBookPortal\blog\includes\pods\calendar.cfm: line 50
Called from D:\WebDocs\ScrapBookPortal\blog\tags\layout.cfm: line 56
Called from D:\WebDocs\ScrapBookPortal\blog\index.cfm: line 148

366 : where
367 : posted >= <cfqueryparam value="#dtMonth#" cfsqltype="CF_SQL_DATE">
368 : and posted <= <cfqueryparam value="#dtEndOfMonth#" cfsqltype="CF_SQL_DATE">
369 : </cfquery>
370 :

Paul, you are using MS Access, did you remember to update the ini file and set the db type to MSACCESS?

Hey Paul that was the first error I got when I installed it for the first time.
I deleted the whole thing, restarted the server placed everything back. Reedited the INI file.
Raymond put me on the right track. :)

noticed in the comments of blog.cfc the following line:
lower cased table names for mysql issue on linux (rkc 2/1/04)

I had to go update all the table names in blog.cfc to match the database. Lower case table names were causing errors. Was this supposed to be fixed? I'm running MySql on Linux

Jeff, yes, it should be fixed. I double checked and the blog.cfc uses all lowercase table names. Are you sure you got the latest zip?

Raymond -- this is my first time trying to get your blog to work. I'm having a tough time trying to figure out how to integrate my own login system (which is simple a SQL table lookup + session variables) with your blog. I'm guessing people have asked you this a million times...I couldn't possibly be the first, right? In any case, any help would be greatly appreciated. - Sung

i was trying to install the blog on my server, but my provider hasn't updated to mx yet. is there any way i could get an older version of the blog that doesn'nt use tags specific to mx (like the cflogin tag).

thanks!

Rob - the Blog has always used CFCs so it always needs MX. The latest version needs MX 6.1.

then i guess i'll need to put some pressure on my provider . . .

thank you for responding so quickly!

I also got the [ODBC Microsoft Access Driver] Too few parameters. Expected 3. The same problem as the other Paul. Could Access have trouble with the dateStr format?

Thanks Raymond for your contributions to the ColdFusion community.

Both Pauls: First Paul, I notice you were using the sequelink driver, which is the ODBC Socket connection. In general, I think you should instead be using the normal MS Access driver. However, as Paul 2 has shown, this throws an error for him. Paul 2 - I'll try my MS Access tests here again, although it may be a day or two.

Just tested and I don't have any problems. Paul2, maybe you can send me your database and a zip of your blog install pls?

Sung - sorry - I missed your post. When you attempt to logon the blog client app calls authenticate() on the blog.cfc. All you need to do is change that logic to point to some other cfc, or do a simple database lookup. Does that make sense?

Thanks for all of the help folks. I ultimately gave up on Access and used MS SQL. I also reinstalled from scratch. Some of the things I did differently:

1) when editing the the blog.ini, I removed the unused sections, and used datasource here.
2) In the application.cfm, for the <cfset application.root = "scrapbookportal_blog"> entry, make sure this is your mapping name and not the datasource.
3) RESTART CF or even the server. This is a must as the incorrect mapping will be kept in cache until this done.

Ultimately, I think #2 & #3 were causing my problems, as it was confused as to where things were located. I even got this after working SQL, as I hadn't cleared it. I did not go back and try Access (ran out of time, and I'd rather use SQL anyway...).

Hope this helps. Start fresh, make sure your mappings and datasources are straightend out, and reboot!

Paul #1

Oops, now that I've spoken, what would cause the blog entries to only show up if you're in design mode? There's only one entry.

http://www.scrapbookportal....
http://www.scrapbookportal....

Thanks. Almost there.

We use caching when designmode is false, HOWEVER, when you add a new entry, we should be clearing the cache. Tell me, if you restart CF, do the entries show up?

Thanks Ray, that did the trick, we're up. I'm glad, as I need to stop restarting the server! Looks like we're good to go, thanks!

Paul - please note that you should NOT need to restart CF everytime you post. If you find this to be the case, please let me know.

No, I understand, I already have my own blog running 2.0 and have been for months. I feel comfortable that I'm ok now, It was just getting through the initial install period. Thanks again. By the way, are you keeping a list of blogs using your code? Would be interesting.

Raymond, I had to restart my CF MX 6.1 server the first time as well. No matter how many times I deleted the code, re-inserted it the same errors happened. After restarting, the fixes you told me to do, finally worked. This restarting may be a point to note.

Raymond, sorry to be a pain, but I continue to not have the most current post show up at default. I have two entries (one for the 5th and one for the 6th). When you arrive for the first time, you see the 5th entry, and until you click on he 6th date (even though it's highlighted), or click on the listed "Recent Entry" you don't see the 6th's entry.

No worries about being a pain. Tell me, if you restart CF does the issue go away and does the blog act correctly (if you don't add anything new that is).

Yes a CF restart fixes the problem. Is it a caching issue?

Ok, there is a caching issue then. Do this, go to /tags/scopecache.cfm. Line 76 should be:

cfset structClear(ptr["scopeCache"])

If it's not, stop and tell me. If it is, right after it, add a cfoutput and display, HEY I WAS CALLED TO CLEAR THE CACHE. Then add a cfabort.

Add a new entry. You _should_ see the msg and the editor window will not close. Check the blog in the browser after you have logged in. Is the entry there? Also, make _sure_ your browser isn't caching.

Yes, the entry is there.

Paul, I'm confused - you said the entry shows up - but I thought it wasn't showing up? If you logout does it still not show up? Also, if possible email me and if I can have RDS access I can take a closer look.

so i'm liking this bloc.cfc and modifying as much as i can figure out. and it's also teaching me alot in the process about cfc's. this is a great teaching tool. thanks!

so a question: i would like to edit the dates of individual entries without having to go to the database. how would you recommend one could go about adding this feature to editor.cfm?

again, thanks for doing this!

Right now you have to either edit the editor.cfm or go straight to ethe db. The best solution is to edit editor.cfm. If people think this is important enough, I'll add it to the next release.