IIS + MySql

http://forums.microsoft.com/TechNet-JA/ShowPost.aspx?PostID=2113684&SiteID=36

http://learn.iis.net/page.aspx/246/using-fastcgi-to-host-php-applications-on-iis-70/#Windows_Server_2008:_

https://www.microsoft.com/japan/opensource/php/learning/default.mspx

http://dev.mysql.com/downloads/mysql/5.1.html#win32

PHP5でMySQLを有効にする（Windows）

1. PHP設定ファイル（PHP.ini）の「;extension=php_mysql.dll」のコメントを解除。

2. PHP設定ファイル（PHP.ini）のextension_dirにphp_mysql.dllを追加。（例：extension_dir = "c:\php\ext\"）

3. PHPインストール先（例：c:\php）にあるlibmysql.dllをWindowsディレクトリ（例：c:\windows）にコピー。

4. IIS7を再起動。

http://phponwindows.net/Joomla.aspx

http://forum.joomla.jp/download.html

http://tedia.jp/installmaniax/2008/im2008_oss.html

Force.com Sites Developer

http://cloud-developer-edition.na6.force.com/cloud

http://wiki.apexdevnet.com/index.php/Developer_Challenge_Guide
http://wiki.apexdevnet.com/index.php/Announcing_Visualforce

http://wiki.apexdevnet.com/index.php/Force.com_Tutorial:_An_Introduction_to_Visualforce

http://developerforce.s3.amazonaws.com/books/Forcedotcom_workbookv2.pdf

SOQL Questions

Q. Does anyone know an easy way to simulate a SELECT DISTINCT operation in SOQL?
Also, how do you check for NULL in a WHERE clause. I know IS NULL does not work?

A. SELECT Id FROM CASE WHERE Id <> null
or
SELECT Id FROM CASE WHERE Id = null

don't think there's anything like distinct though

http://community.salesforce.com/sforce/board/message?board.id=NET_development&message.id=2406&query.id=8066#M2406

---

Q. Join
Accessing Query Results from a Relationship Query from the Partner WSDL with Axis for Java

http://wiki.apexdevnet.com/index.php/Accessing_Query_Results_from_a_Relationship_Query_from_the_Partner_WSDL_with_Axis_for_Java







Q. Update many rows

sql = "select id from Product2 where ProductCode like '%.jp%' and Family <> 'blog' "
query_result = client.query( sql )

if ( query_result['records'].__len__() < 1 ): 
  self.response.out.write('no product found with : %s ' % sql )
else   :
  products = query_result['records']
  for  product in products:       
    product['Family'] = 'blog'
    results = client.update( product )

    self.response.out.write( results )
    if results[0]['success'] :
      self.response.out.write( 'updated. ' )
    else:
      self.response.out.write( results[0]['errors'] )
      self.response.out.write( 'Error. ' )

Cannot build indexes that are in state ERROR.

Uploading index definitions.
Error 400: --- begin server output ---
Cannot build indexes that are in state ERROR.

To vacuum and rebuild your indexes:
1. Create a backup of your index.yaml specification.
2. Determine the indexes in state ERROR from your admin console: http://appengine.google.com/datastore/indexes?&app_id=blog-editor
3. Remove the definitions of the indexes in ERROR from your index.yaml file.
4. Run "appcfg.py vacuum_indexes your_app_dir/"
5. Wait until the ERROR indexes no longer appear in your admin console.
6. Replace the modified version of your index.yaml file with the original.
7. Run "appcfg.py update_indexes your_app_dir/"
--- end server output ---
Your app was updated, but there was an error updating your indexes. Please retry later with appcfg.py update_indexes.




C:\google>appcfg.py vacuum_indexes blog-editor/
Fetching index definitions diff.
This index is no longer defined in your index.yaml file.

ancestor: true
kind: BlogUrlYm
properties: []

Are you sure you want to delete this index? (N/y/a): y
This index is no longer defined in your index.yaml file.

ancestor: true
kind: Blog
properties: []


Are you sure you want to delete this index? (N/y/a): y
This index is no longer defined in your index.yaml file.

ancestor: true
kind: Stock
properties: []


Are you sure you want to delete this index? (N/y/a): y
This index is no longer defined in your index.yaml file.

ancestor: true
kind: Img
properties: []


Are you sure you want to delete this index? (N/y/a): y
This index is no longer defined in your index.yaml file.

kind: Blog
properties:
- direction: desc
name: ym


Are you sure you want to delete this index? (N/y/a): y
This index is no longer defined in your index.yaml file.

ancestor: true
kind: Timeline
properties: []


Are you sure you want to delete this index? (N/y/a): y
Deleting selected index definitions.

C:\google>appcfg.py update_indexes blog-editor/
Uploading index definitions.

ASSETS / 納入商品 Force.com

Account - Assset - Product2

ASSETS / 納入商品とは?
会社が販売する品目が商品であるのに対し、

納入商品とは、販売品のシリアル番号、購入日、その他の情報なども含め、

顧客が購入した特定の商品を表します。

組織における納入商品の使用方法によっては、顧客が所有する競合商品や

自社商品のバージョンを表すこともあります。

組織で商品を有効にした場合、その組織では納入商品が自動的に有効になります。

ただし、ユーザが納入商品を使用するには、まず、

システム管理者が自身の組織をカスタマイズする必要があります。

取引先、取引先責任者、および商品ページレイアウトに納入商品関連リストを追加します。

https://na6.salesforce.com/help/doc/en/sf.pdf

cloud to cloud

http://cloud-cloud.appspot.com/

Error: Method Not Allowed

The request method GETis inappropriate for the URL /login.

local の SDK では問題なく動作していた
Force.com for Google App Engine　

も実際に cloud にupload してみると、動作せず。

app.yaml 　の　secure: always で hppts にしているためかなのかと

思ったが、　どうやら static 静的な html から post している部分が

原因であるようで、 template の html を利用するようにしたところ

cloud でも無事動作した。

Force.com for Google App Engine 日本語

日本語を含んだ contact を登録しようとしたところ、
正しく登録できなかったが、

static/create_contract.py に　#!-*- coding:utf-8 -*-　を追加し
static/create_contract_input.html に以下を追加することで
<meta equiv="Content-Type" content="text/html; charset=utf-8">
登録することができた。

Account Lookup Sample

Enter your credentials:

Username:
Password:

Enter an account name:

     

Found 1 accounts:

Blog-Editor [View Info] 

Account Info:

Name: Blog-Editor 
ID: 0018000000MwqAqAAJ 
Phone: 123456789 
Web Site: 

Create Contact Sample

Enter your credentials:

Username:
Password:

Enter contact info:

First Name:		Phone:
Last Name:		Email: