Arsip: save file path ???(please urgent)

more 14 years ago
bastian
mohon bantuan temen2 forum
saya mo copy path file ke dalam tabel mysql dengan code:
DateTimeToString(fid,'yyyymmddhhnnss',frmMain.GetServerTime);
sd := cbsubdept.Text;
fn := edfilename.Text;
sql := 'INSERT INTO TPath VALUES ('''+fid+''', '''+sd+''', '''+fn+''')';
namun ternyata hasil recordnya untuk field "Path"
hasilnya D:DataMasterJadwal.xls
harusnya D:\Data\Master\Jadwal.xls
saya dah coba rubah typenya mulai dari varchar, text, longtext hasilnya tetep saja tanda "\" tidak tersimpan.
mohon bantuan temen2 untuk solusinya.
terimakasih.

more 14 years ago
deLogic
karakter '' di MySQL termasuk dalam golongan akrakter khusus, sehingga penulisannya juga khusus, yaitu diawali dengan karakter ''. Jadi jika Anda ingin menuliskan karakter backslash (''), maka Anda harus menuliskan '\'.
[code:1:b1e334b9ab]
\ <-> Backslash (ASCII 92). Represent this character by ‘\\’.
[/code:1:b1e334b9ab]

more 14 years ago
_lmz
hmm. replace '' dengan '\' secara manual kok rasanya PHP banget gitu lho. :P Delphi kan punya fasilitas parameter. pakai dong... Siapa tahu driver anda menggunakan prepared statement untuk parameter (note: tidak untuk semua versi mysql, apabila interface delphi->mysql anda tidak mengerti feature ini maka dia mungkin akan melakukan escaping secara manual, tapi paling tidak "it's code you don't have to write").
more ...
- Pages:
- 1
reply |
Report Obsolete
Last Articles
- Project Group dalam Lazarus
- FastPlaz Database Explorer
- Release: FastPlaz Super Mom v0.12.22
- PascalClass #3: Web Development with Free Pascal
- Makna Pascal di Pascal Indonesia
- Kulgram : Instalasi Lazarus di Perangkat Berbasis ARM
- PascalClass #1: Analisa Database dan Machine Learning
- PascalTalk #6: (Podcast) Kuliah IT di luar negeri, susah gak sih?
- Mengenal OXYGENE – Pascal For .NET
- PascalTalk #5: UX: Research, Design and Engineer
Last Topic
- PascalTalk #6: (Podcast) Kuliah IT di luar negeri, susah gak sih?
by LuriDarmawan in Tutorial & Community Project more 3 months ago - PascalTalk #5: UX: Research, Design and Engineer
by LuriDarmawan in Tutorial & Community Project more 3 months ago - PascalTalk #4: Obrolan Ringan Seputar IT
by LuriDarmawan in Tutorial & Community Project more 4 months ago - PascalTalk #2: Membuat Sendiri SMART HOME
by LuriDarmawan in Tutorial & Community Project more 4 months ago - PascalTalk #3: RADically Fast and Easy Mobile Apps Development with Delphi
by LuriDarmawan in Tutorial & Community Project more 4 months ago - PascalTalk #1: Pemanfaatan Artificial Intelligence di Masa Covid-19
by LuriDarmawan in Tutorial & Community Project more 4 months ago - Tempat Latihan Posting
by LuriDarmawan in OOT more 1 years ago - Archive
- Looping lagi...
by idhiel in Hal umum tentang Pascal Indonesia more 8 years ago - [ask] koneksi ke ODBC user Dsn saat runtime dengan ado
by halimanh in FireBird more 8 years ago - Validasi menggunakan data tanggal
by mas_kofa in Hal umum tentang Pascal Indonesia more 8 years ago
Random Topic
- Mengganti karakter
by daru6ia in Tip n Trik Pemrograman more 12 years ago - Quick Report
by marvel in Reporting more 15 years ago - Flash ActiveX pada Delphi 2007
by sudrun in Tip n Trik Pemrograman more 12 years ago - thread di delphi....
by yadi in Hal umum tentang Pascal Indonesia more 13 years ago - Select Outer Join Dengan Bulan Skarang
by delphi1st in Tip n Trik Pemrograman more 13 years ago - ajari ya caranya tipe data delphi+ms access
by pits_its in Tutorial & Community Project more 13 years ago - ContextMenu hanya muncul pada node tertentu di TreeView
by eena in Delphi.NET more 14 years ago - gmn y cara memanggil prosedur timer
by vj_edogawa in Tip n Trik Pemrograman more 12 years ago - chart, quick report
by noo_r1r1n in Reporting more 9 years ago - column header selalu ga muncul...
by p2bf in Tip n Trik Pemrograman more 13 years ago