China DOS Union

Originally posted by NaturalJ0 at 2006-9-27 20:58:
The parentheses in that line were typed wrong. `>a.sql` should be together with ECHO.

This is also incorrect:
for /f "tokens=2,3* delims=|" %%i in (txip1.txt)

do ( echo 'update dzhd_t_txfjxx set v_ip=%%k where c_jgbh=%%i and c_txdm=%%j ;' >a.sql)



The prompt is:

E:\ftp>sql.bat
The command syntax is incorrect.

E:\ftp>for /f "tokens=2,3* delims=|" %i in (txip1.txt)

Originally posted by piziliu2004 at 2006-9-28 04:20:
The code I just wrote for you. Hehe. Interested to take a look
Function splitfile(strFile)
Const ForReading = 1,ForWriting=2
Dim i, retstring
Set fso = CreateObject("Scripting.FileSystemObject" ...

Thank you for your enthusiastic help!
But my level is really not good, can you explain it?

Originally posted by tomorrower at 2006-9-28 05:12:

This is also incorrect:
for /f "tokens=2,3* delims=|" %%i in (txip1.txt)

do ( echo 'update dzhd_t_txfjxx set v_ip=%%k where c_jgbh=%%i and c_txdm=%%j ;' >a.sql)



The prompt is:
...

The problem with the code on the first floor is indeed that the redirection is not within the execution range of the FOR statement.

And the modified code here is also incorrect. It is recommended to look at for /?!

The code is modified as follows:
@echo off
for /f "tokens=2,3* delims=|" %%i in (txip1.txt) do (
echo 'update dzhd_t_txfjxx set v_ip=%%k where c_jgbh=%%i and c_txdm=%%j ;' >>a.sql
)
pause

Just found out after posting the thread that the original intention of the landlord is not that the sentence >a.sql is to overwrite. The landlord may want to append >>a.sql

[ Last edited by pengfei on 2006-9-28 at 05:48 ]

Learning

Your tokens shouldn't be 2, 3. Otherwise, change %i.

Hehe, if the token is more than 62, like 100, then what should be done?